The following bug has been logged online:
Bug reference: 2698
Logged by: Lachhman Dass
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
