Dennis <[email protected]> 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
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
