Search Postgresql Archives

Re: How to return a jsonb list of lists (with integers)

Subject: Re: How to return a jsonb list of lists (with integers)
From: Pavel Stehule <pavel.stehule@xxxxxxxxx>
Date: Wed, 17 Feb 2021 17:05:53 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAADeyWizw2O7r+b-2EbCLBeQP9AA2G77xShHRqVpxupH10X6kg@mail.gmail.com>
References: <CAADeyWjis00Lf4ZGZ=SLBBZNcUxiJHHWU7y3zjqRPO2O9+iWEg@mail.gmail.com> <CAKFQuwZzzZ+rr_Zx-zRV6PDUG=RdvnppXwWq12Cis_=fPDxiGQ@mail.gmail.com> <CAADeyWiYkN5+mLa-GnJ7CoeeGOBf4sX+zWE9Cx2PBsPGM_noYQ@mail.gmail.com> <CAKFQuwYgHf=fUbQ-js1Xk5h=E7v_FSwuVyG+eD_JAp=mcPsqaQ@mail.gmail.com> <CAADeyWiSq9Ww5046+aFG3tBH9ipO2Xkn3fmxWs-Y5KL=E4KQjg@mail.gmail.com> <CAADeyWjCunv8icoExMAZA6P9V+_aq4=2wx2ZT-hNR4kHWQofsA@mail.gmail.com> <CAFj8pRBFJb_5yvbDaWEOV2yERMV3PdUqEuJsSAr4Fp5mvf4FmA@mail.gmail.com> <CAADeyWizw2O7r+b-2EbCLBeQP9AA2G77xShHRqVpxupH10X6kg@mail.gmail.com>

st 17. 2. 2021 v 15:34 odesílatel Alexander Farber <alexander.farber@xxxxxxxxx> 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

References:
- How to return a jsonb list of lists (with integers)
  - From: Alexander Farber
- Re: How to return a jsonb list of lists (with integers)
  - From: David G. Johnston
- Re: How to return a jsonb list of lists (with integers)
  - From: Alexander Farber
- Re: How to return a jsonb list of lists (with integers)
  - From: David G. Johnston
- Re: How to return a jsonb list of lists (with integers)
  - From: Alexander Farber
- Re: How to return a jsonb list of lists (with integers)
  - From: Alexander Farber
- Re: How to return a jsonb list of lists (with integers)
  - From: Pavel Stehule
- Re: How to return a jsonb list of lists (with integers)
  - From: Alexander Farber