Re: select into composite type / return

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To:
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: select into composite type / return
Date: 2021-03-18 11:20:24
Message-ID: efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 18/03/2021 10:39, Torsten Grust wrote:
> Hi Gary,
>
> a shot in the dark but maybe
>
> SELECT id, (do_breakdown(id)).*
> FROM   ...
>
>
> already does the job?  (I'm on 13.2 here and my quickly whipped up
> example shows the desired behavior.)
>
> Best wishes,
>    —Torsten

Perfect, did exactly what I wanted.  I must have tried pretty much every
option except that one.

Thanks

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2021-03-18 14:28:33 Re: select into composite type / return
Previous Message Torsten Grust 2021-03-18 11:10:06 Re: select into composite type / return