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 subscript, if needed. Do not
> includ
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
Oops, I am sorry for the formatting - Mac + Terminal + Gmail :-/
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
