From seethalakshmi.vb@majoris.com Wed Jan  29 11:04:09 2003
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 9E71947703D
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 06:04:09 -0500 (EST)
Received: from canopus.majoris.com (unknown [164.164.88.66])
	by postgresql.org (Postfix) with ESMTP id A87154774AD
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 05:47:04 -0500 (EST)
Received: (from root@localhost)
	by canopus.majoris.com (8.10.2+Sun/8.10.2) id h0TAhU509898
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 16:13:30 +0530 (IST)
Received: from nodnsquery(172.20.10.5) by canopus.majoris.com via csmap (2.0)
	id srcAAAocaivt; Wed, 29 Jan 03 16:13:30 +0530
Received: from xyz ([172.20.10.137]) by electra.majoris.com
	(Netscape Messaging Server 4.15) with SMTP id H9H1WH00.Q76 for
	<pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 16:15:53 +0530
Message-ID: <004b01c2c784$79e115c0$890a14ac@majoris.com>
From: "Seethalakshmi VB" <seethalakshmi.vb@majoris.com>
To: <pgsql-sql@postgresql.org>
Subject: returning table from a function
Date: Wed, 29 Jan 2003 16:22:11 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0048_01C2C7B2.9380E7C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/15
X-Sequence-Number: 11413

This is a multi-part message in MIME format.

------=_NextPart_000_0048_01C2C7B2.9380E7C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi
How to return a user created table from a function?


------=_NextPart_000_0048_01C2C7B2.9380E7C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000080 size=3D2>Hi</FONT></DIV>
<DIV><FONT color=3D#000080 size=3D2>How to return a user created table from=
 a=20
function?</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0048_01C2C7B2.9380E7C0--




From mallah@trade-india.com Sun Feb  2 13:02:27 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id DDF7F4759BD
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 08:02:27 -0500 (EST)
Received: from rtlocal.trade-india.com (mail-relay.trade-india.com
	[203.196.129.235])
	by postgresql.org (Postfix) with SMTP id 77CFA475956
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 08:02:23 -0500 (EST)
Received: (qmail 15710 invoked from network); 2 Feb 2003 12:58:56 -0000
Received: from ns1.trade-india.com (HELO www.trade-india.com) (66.234.10.14)
	by infocom-236-129-del.trade-india.com with SMTP;
	2 Feb 2003 12:58:56 -0000
Received: (qmail 2098 invoked by uid 99); 2 Feb 2003 13:02:28 -0000
Received: from 203.122.61.30 (proxying for 203.122.1.103)
	(SquirrelMail authenticated user mallah)
	by mail.trade-india.com with HTTP;
	Sun, 2 Feb 2003 18:32:28 +0530 (IST)
Message-ID: <6503.203.122.61.30.1044190948.squirrel@mail.trade-india.com>
Date: Sun, 2 Feb 2003 18:32:28 +0530 (IST)
Subject: Re: returning table from a function
From: <mallah@trade-india.com>
To: <seethalakshmi.vb@majoris.com>
In-Reply-To: <b1e1th$eu0$1@news.hub.org>
References: <b1e1th$eu0$1@news.hub.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
Cc: <pgsql-sql@postgresql.org>
X-Mailer: SquirrelMail (version 1.2.6)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/30
X-Sequence-Number: 11428



Hmm..

do you mean functions returning sets then

http://techdocs.postgresql.org/guides/SetReturningFunctions

is for you.


regds
mallah.


-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/