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 1lOIJj-00070n-Ml
	for pgsql-sql@arkaria.postgresql.org; Mon, 22 Mar 2021 11:01:51 +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 1lOIJi-0002J7-Jl
	for pgsql-sql@arkaria.postgresql.org; Mon, 22 Mar 2021 11:01:50 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	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 1lOIJi-0002Iz-DG
	for pgsql-sql@lists.postgresql.org; Mon, 22 Mar 2021 11:01:50 +0000
Received: from hub.ringways.co.uk ([88.211.105.30] helo=ringways.co.uk)
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <gary.stainburn@ringways.co.uk>)
	id 1lOIJc-0007Eq-2h
	for pgsql-sql@lists.postgresql.org; Mon, 22 Mar 2021 11:01:49 +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 1lOIJa-0004dx-Ii
	for pgsql-sql@lists.postgresql.org; Mon, 22 Mar 2021 11:01:42 +0000
Subject: Re: select into composite type / return
To: 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>
 <CAGqkgphmj3uHB3Jc5Eb=yA2cfffHFsACWR3Fbfr6jrkQepKJPA@mail.gmail.com>
 <3718235.1616077713@sss.pgh.pa.us>
 <e13395d5-10e5-3e83-1dd1-ad5d98d0e8b7@ringways.co.uk>
 <9fb9f646-58be-cb17-b144-664c46f6cd01@ringways.co.uk>
 <CAFj8pRDaD1L85UxP6ScQv4GUnEqMw9EjpFmTqippRZL1DGhT5Q@mail.gmail.com>
 <5f54e16c-63b4-f1b4-91ff-1ccefd271139@ringways.co.uk>
 <CAFj8pRBGWLkD=Q6fdp-Sq_2L8f+1etJuA-PfZf=-67hWrJnC2w@mail.gmail.com>
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Message-ID: <7dc52003-94f1-cc2d-7f87-2b14a3210857@ringways.co.uk>
Date: Mon, 22 Mar 2021 11:01:41 +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: 
 <CAFj8pRBGWLkD=Q6fdp-Sq_2L8f+1etJuA-PfZf=-67hWrJnC2w@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------61C39A841008C84C7EA33FDA"
Content-Language: en-US
X-Spam-Score: -49.8 (-------------------------------------------------)
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 22/03/2021 10:56,
 Pavel Stehule wrote: > probably you can
    write > > D := do_breakdown(...); > > and it will be faster > > Pavel That
    also worked, which surprised me as I thought I'd already Tried that. [...]    
 Content analysis details:   (-49.8 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
  0.0 HTML_MESSAGE           BODY: HTML included in message
  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/7dc52003-94f1-cc2d-7f87-2b14a3210857%40ringways.co.uk>
Precedence: bulk

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

On 22/03/2021 10:56, Pavel Stehule wrote:
> probably you can write
>
> D := do_breakdown(...);
>
> and it will be faster
>
> Pavel

That also worked, which surprised me as I thought I'd already Tried that.

Thanks.

Gary

--------------61C39A841008C84C7EA33FDA
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 22/03/2021 10:56, Pavel Stehule wrote:<br>
    <blockquote type="cite"
cite="mid:CAFj8pRBGWLkD=Q6fdp-Sq_2L8f+1etJuA-PfZf=-67hWrJnC2w@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_quote">probably you can write
          <div><br>
          </div>
          <div>D := do_breakdown(...);</div>
          <div><br>
          </div>
          <div>and it will be faster</div>
          <div><br>
          </div>
          <div>Pavel<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    That also worked, which surprised me as I thought I'd already Tried
    that.<br>
    <br>
    Thanks.<br>
    <br>
    Gary<br>
  </body>
</html>

--------------61C39A841008C84C7EA33FDA--