From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: returning results from an update for joining other tables |
Date: | 2008-06-10 09:07:31 |
Message-ID: | 20080610090731.GC25980@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Scharrenberg | 2008-06-10 09:32:44 | Re: returning results from an update for joining other tables |
Previous Message | Patrick Scharrenberg | 2008-06-10 08:50:52 | returning results from an update for joining other tables |