Re: returning results from an update for joining other tables - Mailing list pgsql-sql

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 <48468922.9030108@enterprisedb.com>

Oh, I see.

Are there ways to work around this limitation?

Patrick