Re: UPDATE from CTE syntax error

On Sat, May 26, 2018 at 6:37 PM, Adrian Klaver 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

Re: UPDATE from CTE syntax error

On 05/26/2018 09:21 AM, Alexander Farber wrote: Good evening, I am struggling with the syntax, please help. This query with a CTE works ok: WITH      

Re: UPDATE from CTE syntax error

Oops, I am sorry for the formatting - Mac + Terminal + Gmail :-/

UPDATE from CTE syntax error

Good evening, I am struggling with the syntax, please help. This query with a CTE works ok: WITH extract_letters AS ( SELECT mid, STRING_AGG(x->>'letter', '') AS letters