DEV Community

loading...

Discussion on: Simple Queue in PostgreSQL

Collapse
davidjamesstone profile image
David Stone

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