Re: Why the "UPDATE tab SET tab.col" is invalid? - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Why the "UPDATE tab SET tab.col" is invalid?
Date
Msg-id CAHyXU0yyVfB4N3bHADuoORW_wPVGZ3n9we9ntuhxaMYEmZNatw@mail.gmail.com
Whole thread Raw
In response to Why the "UPDATE tab SET tab.col" is invalid?  ("postgres_sure"<postgres_sure@163.com>)
Responses Re: Why the "UPDATE tab SET tab.col" is invalid?  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-hackers
On Thu, Apr 7, 2016 at 4:39 AM, postgres_sure <postgres_sure@163.com> wrote:
> Hi,
>
> I found "Do not include the table's name in the specification of a target
> column
>                  — for example, UPDATE tab SET tab.col = 1 is invalid." in
> the documentation.
>
> Some people usually like to update table by alias. They want to add this
> feature.

Is this syntax described in the SQL standard?

merlin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgbench randomness initialization
Next
From: Thomas Munro
Date:
Subject: Re: WIP: Detecting SSI conflicts before reporting constraint violations