>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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
