Re: returning results from an update for joining other tables

From: Patrick Scharrenberg <pittipatti(at)web(dot)de>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: returning results from an update for joining other tables
Date: 2008-06-10 09:32:44
Message-ID: 484E4A3C.60504@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)9030108(at)enterprisedb(dot)com>

Oh, I see.

Are there ways to work around this limitation?

Patrick

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shavonne Marietta Wijesinghe 2008-06-10 09:56:39 Nextval & Currval
Previous Message A. Kretschmer 2008-06-10 09:07:31 Re: returning results from an update for joining other tables