Re: Uniform UPDATE queries

Hello Tom,

The example you have given is EXACTLY why something like CURRENT is needed to limit the number of
unique queries or prepared statements. (or to do a selection of all values before an update meaning
two executed queries.)

regards,.

Dennis

On 04/18/2012 06:24 PM, Tom Lane wrote:
> Dennis<dennis(dot)verbeek(at)victorem(dot)com> writes:
>> When a query is written to update a table, the usual process is to list all the columns that need
>> updating. This could imply the creation of many possible queries for many columns. In an effort to
>> keep the UPDATE queries more uniform, less number of unique queries, a keyword similar to DEFAULT,
>> let's say CURRENT, is required to indicate that the current value must not change.
> No it isn't. Just write the name of the column, eg
>
> update mytable set x = x, y =<new value>, z = z where ...
>
> There's no reason to invent nonstandard syntax for this.
>
> regards, tom lane
>
>
>