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

From Gary Stainburn
Subject Re: select into composite type / return
Date
Msg-id 9eb42b06-9cfa-1e4b-e42b-6f64e99675a5@ringways.co.uk
Whole thread Raw
In response to Re: select into composite type / return  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: select into composite type / return  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: select into composite type / return
Next
From: Gary Stainburn
Date:
Subject: Re: select into composite type / return