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