Re: UPDATE syntax - Mailing list pgsql-general

From David Greco
Subject Re: UPDATE syntax
Date
Msg-id 187F6C10D2931A4386EE8E58E13857F612931116@BY2PRD0811MB415.namprd08.prod.outlook.com
Whole thread Raw
In response to Re: UPDATE syntax  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
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.



No problem, just looking to be a bit lazy, and avoid the potential for copy-paste errors and such.





pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: difference in query performance due to the inclusion of a polygon geometry field
Next
From: "Bijelic, Aleksandra (Lexi)"
Date:
Subject: Mailing list Question