Returning multiple rows in 8.4

From: Baris Gerze <barisgerze(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Returning multiple rows in 8.4
Date: 2009-11-09 22:23:33
Message-ID: 4AF89665.8090402@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Baris Gerze 2009-11-09 22:30:46 [Fwd: Returning multiple rows in 8.4]
Previous Message hubert depesz lubaczewski 2009-11-09 22:13:51 Re: What to install to be able to build docs on Arch Linux?