Re: select into composite type / return

pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed

From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: select into composite type / return
Date: Thu, 18 Mar 2021 11:20:24 +0000
Message-ID: <efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk> (raw)
In-Reply-To: <CAGqkgpgMHSwAb6DB6=q=Js=fNOdXkqSk+_9tUEyK5PdrBqwT5g@mail.gmail.com>
References: <39dcfab9-4eb2-382b-9186-baf722ca56a0@ringways.co.uk>
	<3523853.1616002010@sss.pgh.pa.us>
	<9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@ringways.co.uk>
	<7af5d693-a6a3-d3d4-050a-0898aad8bd77@ringways.co.uk>
	<CAGqkgpgMHSwAb6DB6=q=Js=fNOdXkqSk+_9tUEyK5PdrBqwT5g@mail.gmail.com>

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

view thread (14+ messages)  latest in thread

Message-ID: <efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk>
Permalink:  ../efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk/
Also on:    postgresql.org/message-id/efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk

 ·

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: gary.stainburn@ringways.co.uk, pgsql-sql@lists.postgresql.org
  Subject: Re: select into composite type / return
  In-Reply-To: <efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox