Postgres Pro
Downloads
Home   >   mailing lists

Thread: function with multi-values

function with multi-values

From
Harry Yau
Date:
Dear:
    I wanna create a function that return a multiple rows in to a single

row.
example:
CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
TEST;' LANGUAGE 'SQL';

when i call this function it return:
----------
peter
susan
john

but I wonder is it possible to make it to return something like
---------------------
peter    susan    john

I have to use this result to print in quick report.
THANK YOU VERY MUCH

Harry Yau

Re: function with multi-values

From
"Eric G. Miller"
Date:
On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote:
> Dear:
>     I wanna create a function that return a multiple rows in to a single
>
> row.
> example:
> CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
> TEST;' LANGUAGE 'SQL';
>
> when i call this function it return:
> ----------
> peter
> susan
> john
>
> but I wonder is it possible to make it to return something like
> ---------------------
> peter    susan    john
>
> I have to use this result to print in quick report.
> THANK YOU VERY MUCH

Maybe you want your function to iterate through the records and return a
string of concatenated results?  Or does it need to be a tuple?  To do
so, I think you'd need to use pgplsql.

--
Eric G. Miller <egm2@jps.net>

Re: Re: function with multi-values

From
Harry Yau
Date:
>On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote:
>> Dear:
>>     I wanna create a function that return a multiple rows in to a
single
>>
>> row.
>> example:
>> CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
>> TEST;' LANGUAGE 'SQL';
>>
>> when i call this function it return:
>> ----------
>> peter
>> susan
>> john
>>
>> but I wonder is it possible to make it to return something like
>> ---------------------
>> peter    susan    john
>>
>> I have to use this result to print in quick report.
>> THANK YOU VERY MUCH
>
>Maybe you want your function to iterate through the records and return
a
>string of concatenated results?  Or does it need to be a tuple?  To do
>so, I think you'd need to use pgplsql.

I think is will be ok for the first method, but I am not really familiar
with pgplsql.
I am wondering is there any complete referrence for pgplsql online.
Thank You

Harry Yau