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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general