Re: UPDATE syntax

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "David Greco *EXTERN*" <David_Greco(at)harte-hanks(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: UPDATE syntax
Date: 2012-11-30 14:11:26
Message-ID: D960CB61B694CF459DCFB4B0128514C208C99D8A@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-11-30 14:16:15 Re: difference in query performance due to the inclusion of a polygon geometry field
Previous Message icholy 2012-11-30 14:03:24 Re: libpq - PQsendQuery wait for complete result