Re: [GENERAL] function with multi-values

2001-04-28 Thread Eric G. Miller
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

[GENERAL] function with multi-values

2001-04-28 Thread Harry Yau
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