Re: UPDATE syntax - Mailing list pgsql-general

From Albe Laurenz
Subject Re: UPDATE syntax
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208C99D8A@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: UPDATE syntax  (David Greco <David_Greco@harte-hanks.com>)
Responses Re: UPDATE syntax  (David Greco <David_Greco@harte-hanks.com>)
List pgsql-general
David Greco wrote:
[wants to use CTEs in an UPDATE]

> Yeah that's good, but there are plenty of columns, was hoping to be
able to use (table.*) syntax

Is this a problem or do you just want to type
as little as possible?

You have to specify them in the SET clause anyway.

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: icholy
Date:
Subject: Re: libpq - PQsendQuery wait for complete result
Next
From: "Albe Laurenz"
Date:
Subject: Re: difference in query performance due to the inclusion of a polygon geometry field