Thanks for the great article. Can I ask what version of PG you are using please as I I am struggling to get your code running (using PG v12.1)?
When I try and run it complains about the "jq2" aliasing. According to another article, table aliasing can't be done like this as part of an UPDATE statement in PG.
Hi Maximo
Thanks for the great article. Can I ask what version of PG you are using please as I I am struggling to get your code running (using PG v12.1)?
When I try and run it complains about the "jq2" aliasing. According to another article, table aliasing can't be done like this as part of an UPDATE statement in PG.
dba.stackexchange.com/questions/15...
I would really appreciate any help on this - many thanks
Sorry for the super late reply. I have been using this in production with version 11.22.