"xtron" <[EMAIL PROTECTED]> writes:
> this is NOT work:
> update a1 set a1.value = a2.value from a2 where a1.id = a2.id;
This syntax is disallowed by the SQL standard: a SET target is just the
name of the column. If we tried to interpret it as you suggest then
we'd be incompatible for composite-t
The following bug has been logged online:
Bug reference: 4515
Logged by: xtron
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.5
Operating system: Debian GNU/Linux
Description:UPDATE strange behavior
Details:
IMHO this is strange behavior:
create table a1(
