[GENERAL] Returning multiple rows in 8.4

2009-11-09 Thread Baris Gerze
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 selec

[GENERAL] [Fwd: Returning multiple rows in 8.4]

2009-11-09 Thread Baris Gerze
--- Begin Message --- 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 w