[Fwd: Returning multiple rows in 8.4]

[Baris Gerze <barisgerze@xxxxxxxxx>]

--- Begin Message ---

• To: pgsql-general@xxxxxxxxxxxxxx
• Subject: Returning multiple rows in 8.4
• From: Baris Gerze <barisgerze@xxxxxxxxx>
• Date: Tue, 10 Nov 2009 00:23:33 +0200
• User-agent: Thunderbird 2.0.0.23 (X11/20090817)

I have users table such as
 create table users(
   user_id   bigserial,
   user_name varchar(50),
   user_surname varchar(100)
 );


how can I write a function to return multiple rows? ( in plpgsql )

what is the return value of the function? records?


and how can i run it without running as select my_func() as (int8,
varchar) ???
is there simple way to do this?

thanks

--- End Message ---

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general