Returning multiple rows in 8.4 - Mailing list pgsql-general

From Baris Gerze
Subject Returning multiple rows in 8.4
Date
Msg-id 4AF89665.8090402@gmail.com
Whole thread Raw
List pgsql-general
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





pgsql-general by date:

Previous
From: Scot Kreienkamp
Date:
Subject: Re: pg_dump native format will not restore correctly
Next
From: David Fetter
Date:
Subject: Re: Editor for sgml files