Re: returning results from an update for joining other tables

am Tue, dem 10.06.2008, um 10:50:52 +0200 mailte Patrick Scharrenberg folgendes:
> Hi!
>
> I have a table containing data and a column which holds information on
> which compute-node processes the data. In a given interval I'd like to
> request some data from this table and mark these returned rows by
> setting the "process_node" column to the node-name, which asked for data.
> There may also be rows which have the column process_node set to the
> name of the node currently asking.
>
> 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>

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net