Re: Why the "UPDATE tab SET tab.col" is invalid?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: postgres_sure <postgres_sure(at)163(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why the "UPDATE tab SET tab.col" is invalid?
Date: 2016-04-07 13:48:28
Message-ID: CAHyXU0yyVfB4N3bHADuoORW_wPVGZ3n9we9ntuhxaMYEmZNatw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Apr 7, 2016 at 4:39 AM, postgres_sure <postgres_sure(at)163(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2016-04-07 13:49:32 Re: WIP: Detecting SSI conflicts before reporting constraint violations
Previous Message Tom Lane 2016-04-07 13:46:27 Re: pgbench randomness initialization