>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