Eus wrote:
> Hi Ho!
>
> Since I can do:
>
> INSERT INTO table (SELECT a_transaction.*);
>
> I am wondering whether I can do:
>
> UPDATE table SET (SELECT a_transaction.*) WHERE primary_key = (SELECT a_transaction.primary_key);
UPDATE table SET fieldname = (SELECT ..) WHERE primary_key = (SELECT...)
--
Craig Ringer