Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1lMqhd-0005fQ-Nq
	for pgsql-sql@arkaria.postgresql.org; Thu, 18 Mar 2021 11:20:33 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1lMqhc-0004q0-6b
	for pgsql-sql@arkaria.postgresql.org; Thu, 18 Mar 2021 11:20:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <gary.stainburn@ringways.co.uk>)
	id 1lMqhb-0004pg-W7
	for pgsql-sql@lists.postgresql.org; Thu, 18 Mar 2021 11:20:31 +0000
Received: from hub.ringways.co.uk ([88.211.105.30] helo=ringways.co.uk)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <gary.stainburn@ringways.co.uk>)
	id 1lMqhZ-0006oz-0C
	for pgsql-sql@lists.postgresql.org; Thu, 18 Mar 2021 11:20:30 +0000
Received: from rwsys1.ringways.co.uk ([10.1.1.105] helo=eddie.ringways.co.uk)
	by ringways.co.uk with esmtpsa  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94)
	(envelope-from <gary.stainburn@ringways.co.uk>)
	id 1lMqhX-0007nU-Rv
	for pgsql-sql@lists.postgresql.org; Thu, 18 Mar 2021 11:20:28 +0000
Subject: Re: select into composite type / return
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
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>
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
Message-ID: <efa1742d-25e5-09f6-77e1-1d9627bd0fd4@ringways.co.uk>
Date: Thu, 18 Mar 2021 11:20:24 +0000
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: 
 <CAGqkgpgMHSwAb6DB6=q=Js=fNOdXkqSk+_9tUEyK5PdrBqwT5g@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------D76BC566B899BFDCBB5F9326"
Content-Language: en-US
X-Spam-Score: -46.9 (----------------------------------------------)
X-Spam-Report: Spam detection software, running on the system "ollie2.ringways.co.uk",
 has NOT identified this incoming email as spam.  The original
 message has been attached to this so you can view it or label
 similar future email.  If you have any questions, see
 Gary Stainburn <gary@ringways.co.uk> for details.
 
 Content preview:  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
    [...] 
 
 Content analysis details:   (-46.9 points, 15.0 required)
 
  pts rule name              description
 ---- ---------------------- --------------------------------------------------
  -50 ALL_TRUSTED            Passed through trusted hosts only via SMTP
 -1.9 BAYES_00               BODY: Bayes spam probability is 0 to 1%
                             [score: 0.0000]
  0.1 SCORE_RCPTS            Adding score for each recipient
  4.0 TO_EMPTY               Empty TO header
  1.0 MISSING_HEADERS        Missing To: header
  0.0 HTML_MESSAGE           BODY: HTML included in message
 -2.1 AWL                    AWL: Adjusted score from AWL reputation of From: address
  1.0 MISSING_FROM           Missing From: header
 -0.0 NICE_REPLY_A           Looks like a legit reply (A)
  1.0 RING_SAFE              No description available.
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/efa1742d-25e5-09f6-77e1-1d9627bd0fd4%40ringways.co.uk>
Precedence: bulk

This is a multi-part message in MIME format.
--------------D76BC566B899BFDCBB5F9326
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------D76BC566B899BFDCBB5F9326
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 18/03/2021 10:39, Torsten Grust wrote:<br>
    <blockquote type="cite"
cite="mid:CAGqkgpgMHSwAb6DB6=q=Js=fNOdXkqSk+_9tUEyK5PdrBqwT5g@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hi Gary,
        <div><br>
        </div>
        <div>a shot in the dark but maybe</div>
        <div><br>
        </div>
        <blockquote style="margin:0 0 0 40px;border:none;padding:0px">
          <div>SELECT id, (do_breakdown(id)).* </div>
          <div>FROM   ...</div>
        </blockquote>
        <div><br>
        </div>
        <div>already does the job?  (I'm on 13.2 here and my quickly
          whipped up example shows the desired behavior.)</div>
        <div><br>
        </div>
        <div>Best wishes,  </div>
        <div>   —Torsten</div>
      </div>
    </blockquote>
    <br>
    Perfect, did exactly what I wanted.  I must have tried pretty much
    every option except that one.<br>
    <br>
    Thanks<br>
  </body>
</html>

--------------D76BC566B899BFDCBB5F9326--