Home > mailing lists

Select a column and then apply JSONB_ARRAY_ELEMENTS to it - Mailing list pgsql-general

From	David G. Johnston
Subject	Select a column and then apply JSONB_ARRAY_ELEMENTS to it
Date	January 9, 2021 14:49:04
Msg-id	CAKFQuwYnpTuJsG0buf29fpTtgynp5YnW51qB-PBgGTKM9Ya-CA@mail.gmail.com Whole thread Raw
In response to	Select a column and then apply JSONB_ARRAY_ELEMENTS to it (Alexander Farber <alexander.farber@gmail.com>)
Responses	Re: Select a column and then apply JSONB_ARRAY_ELEMENTS to it
List	pgsql-general

On Saturday, January 9, 2021, Alexander Farber <alexander.farber@gmail.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.

From: "Markhof, Ingolf"
Date: 09 January 2021, 14:22:25
Subject: RE: How to keep format of views source code as entered?

From: Christophe Pettus
Date: 09 January 2021, 15:09:26
Subject: Re: How to keep format of views source code as entered?