Re: Can I use a query with UPDATE on its SET? - Mailing list pgsql-general

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