Re: UPDATE from CTE syntax error - Mailing list pgsql-general

From Alexander Farber
Subject Re: UPDATE from CTE syntax error
Date
Msg-id CAADeyWgqvfxxZES5+JAk8oZ7JdvSLEioC4KdN5byKX1wt24CNw@mail.gmail.com
Whole thread Raw
In response to Re: UPDATE from CTE syntax error  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Sat, May 26, 2018 at 6:37 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

https://www.postgresql.org/docs/10/static/sql-update.html
"column_name

    The name of a column in the table named by table_name. The column name can be qualified with a subfield name or array subscript, if needed. Do not include the table's name in the specification of a target column — for example, UPDATE table_name SET table_name.col = 1 is invalid.
"

So it should be:

SET letters = el.letters


Thank you Adrian, this has worked
 

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Syndicating PostgreSQL mailing list to Discourse
Next
From: Peter Geoghegan
Date:
Subject: Re: Syndicating PostgreSQL mailing list to Discourse