Thread: BUG #2698: Update table alias not supported

BUG #2698: Update table alias not supported

From
"Lachhman Dass"
Date:
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

Re: BUG #2698: Update table alias not supported

From
Peter Eisentraut
Date:
Lachhman Dass wrote:
> In the Update statement alias must be supported

Says who?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: BUG #2698: Update table alias not supported

From
"Lachhman Dass"
Date:
Most of the relational database support that like : Oracle, DB2, MS SQL Ser=
ver, 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?

--=20
Peter Eisentraut
http://developer.postgresql.org/~petere/