function return multiple value

From: Harry Yau <harry(dot)yau(at)regaltronic(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: function return multiple value
Date: 2001-04-26 07:44:08
Message-ID: 3AE7D1C8.86756865@regaltronic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Darshan.wakchaure 2001-04-26 07:48:02 Run a create object script ???
Previous Message Karel Zak 2001-04-26 07:38:43 Re: Performance: sql functions v. plpgsql v. plperl