Home > mailing lists

Re: How to return a jsonb list of lists (with integers) - Mailing list pgsql-general

From	Pavel Stehule
Subject	Re: How to return a jsonb list of lists (with integers)
Date	February 17, 2021 19:05:53
Msg-id	CAFj8pRCFuf2C3v=PL5uyC6GWSLrj+ZEnQdspAtm+TESB1oYAZA@mail.gmail.com Whole thread Raw
In response to	Re: How to return a jsonb list of lists (with integers) (Alexander Farber <alexander.farber@gmail.com>)
List	pgsql-general

st 17. 2. 2021 v 15:34 odesílatel Alexander Farber <alexander.farber@gmail.com> napsal:

Hi Pavel,

why would SELECT INTO be better here?

Minimally it doen't use undocumented feature. And you can be sure, so the query is evaluated really like a query.

The expressions are evaluated differently.

Regards

Pavel

Thanks
Alex

From: Thomas Kellerer
Date: 17 February 2021, 18:24:29
Subject: Re: Slow while inserting and retrieval (compared to SQL Server)

From: Pavel Stehule
Date: 17 February 2021, 19:10:37
Subject: Re: How to return a jsonb list of lists (with integers)