Re: Uniform UPDATE queries

Dennis <dennis.verbeek@victorem.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