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 taSET process_node='nodename'WHERE a>10 AND process_node is nullRETURNING *
) AS ta
JOIN someothertable ON ...
Can I somehow select some rows and do multiple operations on exactly
this resultset?
In my case update columns, then join columns from other tables and then
return the resultset with the joined columns?
Regards
Patrick