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: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Wed, 17 Feb 2021 15:34:04 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAFj8pRBFJb_5yvbDaWEOV2yERMV3PdUqEuJsSAr4Fp5mvf4FmA@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>

Hi Pavel,

why would SELECT INTO be better here?

Thanks

Alex

Follow-Ups:
- 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

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