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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster