Skip site navigation (1) Skip section navigation (2)

BUG #2698: Update table alias not supported

From: "Lachhman Dass" <lachhmand(at)interrait(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2698: Update table alias not supported
Date: 2006-10-17 07:45:49
Message-ID: 200610170745.k9H7jnex047601@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2698
Logged by:          Lachhman Dass
Email address:      lachhmand(at)interrait(dot)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

Responses

pgsql-bugs by date

Next:From: Lachhman DassDate: 2006-10-17 09:19:45
Subject: BUG #2699: Delete table alias not supported
Previous:From: Rusty ConoverDate: 2006-10-17 04:51:05
Subject: BUG #2697: 8.2beta1 SIGSEGV crash/assertion on insert statement w/ sub-select and placeholders

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group