Yup, converting to a scalar and using the postgres compiler I now see the
correct output. The one other thing I had to fix was `column_literal(*)` vs
`literal(*)` Thanks for the detailed reply.
On Monday, 12 August 2019 18:23:13 UTC-7, Joel Gibson wrote:
>
> Hi all,
>
> I'
Hi all,
I've got a queue in postgres that currently uses a raw sql query to dequeue
items. The queue has multiple "topics" that the metadata/selector uses to
dequeue specific items
DELETE FROM queue
WHERE id = (
SELECT id
FROM queue
WHERE :selector = ANY (metadata)
ORDER BY queue_date
FOR UPDAT