function return multiple value

Started by Harry Yaualmost 25 years ago1 messagesgeneral
Jump to latest
#1Harry Yau
harry.yau@regaltronic.com

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