agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: Re: select into composite type / return
Date: Wed, 17 Mar 2021 17:42:34 +0000
Message-ID: <9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@ringways.co.uk> (raw)
In-Reply-To: <3523853.1616002010@sss.pgh.pa.us>
References: <39dcfab9-4eb2-382b-9186-baf722ca56a0@ringways.co.uk>
	<3523853.1616002010@sss.pgh.pa.us>

On 17/03/2021 17:26, Tom Lane wrote:
> AFAICS these two functions will have exactly the same output behavior,
> ie returning a "breakdown" composite type.  If they act differently
> for you, either you are calling them in different ways or you made
> a mistake somewhere.  I can't help noticing that the RETURN in the
> second function is calling a six-argument function, which is not the
> one you showed first.  Maybe that version of do_breakdown() returns
> something different?
>
> 			regards, tom lane
Hi Tom,

Thanks for the quick response.  The missing argument was because I had 
to use pseudo details to protect intellectual property and I miss-typed 
the code.

You were correct.  The problem was not with the functions, but with how 
I was calling them.

Gary

view thread (14+ messages)  latest in thread

Message-ID: <9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@ringways.co.uk>
Permalink:  ../9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@ringways.co.uk/
Also on:    postgresql.org/message-id/9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@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: <9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox