| From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: UPDATE from CTE syntax error |
| Date: | 2018-05-27 14:00:42 |
| Message-ID: | CAADeyWgqvfxxZES5+JAk8oZ7JdvSLEioC4KdN5byKX1wt24CNw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, May 26, 2018 at 6:37 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nasby, Jim | 2018-05-27 16:39:49 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| Previous Message | Stephen Frost | 2018-05-27 13:13:33 | Re: Syndicating PostgreSQL mailing list to Discourse |