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
