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