PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> The bellow command return : ERROR: source for a multiple-column UPDATE item
> must be a sub-SELECT or ROW() expression
> update table set
> (column)=(value)
> where 1=2
The error is telling you what to do. You should write:
update table set
(column) = ROW(value)
where 1=2
The ROW keyword is optional for a multi-column row, since
(v1,v2) couldn't mean anything else. But if there's just
one item, the parentheses are noise; they don't turn it
into a row.
regards, tom lane