returning multiple resultset?

From: iseyfi(at)vt(dot)edu (ismail)
To: pgsql-sql(at)postgresql(dot)org
Subject: returning multiple resultset?
Date: 2004-02-09 23:27:27
Message-ID: 357f5505.0402091527.394e0a30@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello all,

I am fairly new to PostgreSQL and I am right now converting a database
from SQL server. SQL server can return multiple select statements in
the function body. Is there any way to return a function with two
different resultsets?

select * from table1;

select * from table2;

Thanks for your time and help

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Creager 2004-02-10 03:25:33 Re: Implementation of a bag pattern using rules
Previous Message Christian Hergert 2004-02-09 19:49:08 umlimited arguments on function