Thread

1. function with multi-values

   Harry Yau <harry.yau@regaltronic.com> — 2001-04-28T01:46:44Z

   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
   
   
   

2. Re: function with multi-values

   Eric G. Miller <egm2@jps.net> — 2001-04-28T21:05:19Z

   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.
   
   -- 
   Eric G. Miller <egm2@jps.net>