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 retur
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 ret