Select a column and then apply JSONB_ARRAY_ELEMENTS to it

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Select a column and then apply JSONB_ARRAY_ELEMENTS to it
Date: 2021-01-09 14:49:04
Message-ID: CAKFQuwYnpTuJsG0buf29fpTtgynp5YnW51qB-PBgGTKM9Ya-CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, January 9, 2021, Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
wrote:

>
> BEGIN
> FOR _tile IN SELECT * FROM JSONB_ARRAY_ELEMENTS(SELECT tiles FROM
> words_moves WHERE mid = in_mid)
>
>

Subqueries must be enclosed in parentheses. The parentheses that are part
of the function call do not count.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2021-01-09 15:09:26 Re: How to keep format of views source code as entered?
Previous Message Markhof, Ingolf 2021-01-09 14:22:25 RE: How to keep format of views source code as entered?