Postgres Pro
Downloads
Home   >   mailing lists

Re: select into composite type / return - Mailing list pgsql-sql

From Gary Stainburn
Subject Re: select into composite type / return
Date
Msg-id efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk
Whole thread Raw
In response to select into composite type / return  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Torsten Grust
Date:
Subject: Re: select into composite type / return
Next
From: Tom Lane
Date:
Subject: Re: select into composite type / return