Hi! >> >> What I tried was something like this, which gave me a syntax error: >> >> >> >> SELECT * FROM >> >> ( UPDATE ta >> >> SET process_node='nodename' >> >> WHERE a>10 AND process_node is null >> >> RETURNING * >> >> ) AS ta >> >> JOIN someothertable ON ... > > > > It's a know limitation, see <[EMAIL PROTECTED]>
Oh, I see. Are there ways to work around this limitation? Patrick -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
