X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 995DCD1D643
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  9 Feb 2004 23:45:59 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 87996-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  9 Feb 2004 19:45:53 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 9A323D1D55A
	for <pgsql-sql@postgresql.org>; Mon,  9 Feb 2004 19:45:50 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i19Nji1Y092167
	for <pgsql-sql@postgresql.org>; Mon, 9 Feb 2004 23:45:44 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i19NRL7M088598
	for pgsql-sql@postgresql.org; Mon, 9 Feb 2004 23:27:21 GMT
From: iseyfi@vt.edu (ismail)
X-Newsgroups: comp.databases.postgresql.sql
Subject: returning multiple resultset?
Date: 9 Feb 2004 15:27:27 -0800
Organization: http://groups.google.com
Lines: 14
Message-ID: <357f5505.0402091527.394e0a30@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/172
X-Sequence-Number: 16862

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