BUG #2698: Update table alias not supported
The following bug has been logged online:
Bug reference: 2698
Logged by: Lachhman Dass
Email address: lachhmand@interrait.com
PostgreSQL version: 8.0
Operating system: Windows 2000 Professional
Description: Update table alias not supported
Details:
In the Update statement alias must be supported and the syntax should be
UPDATE [ ONLY ] table alias SET column = { expression | DEFAULT } [, ...]
[ FROM fromlist ]
[ WHERE condition ]
this is required when same table is used multiple time in where clause and
you want to restrict the selection.
Thanks,
Lachhman Dass
Lachhman Dass wrote:
In the Update statement alias must be supported
Says who?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Most of the relational database support that like : Oracle, DB2, MS SQL Server, Cloudscape, Derby ... and many more.
Lachhman Dass
-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net]
Sent: Friday, October 20, 2006 12:32 PM
To: pgsql-bugs@postgresql.org
Cc: Lachhman Dass
Subject: Re: [BUGS] BUG #2698: Update table alias not supported
Lachhman Dass wrote:
In the Update statement alias must be supported
Says who?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Import Notes
Resolved by subject fallback