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(dot)9030108(at)enterprisedb(dot)com>
Oh, I see.
Are there ways to work around this limitation?
Patrick