Received: from jupiter.jw.home (A5d16.pppool.de [213.6.93.22]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0DDw4p52672 for ; Sat, 13 Jan 2001 08:58:04 -0500 (EST) (envelope-from janwieck@Yahoo.com) Received: (from janwieck@localhost) by jupiter.jw.home (8.9.3/8.9.3) id JAA01424; Sat, 13 Jan 2001 09:04:59 -0500 From: Jan Wieck Message-Id: <200101131404.JAA01424@jupiter.jw.home> Subject: Re: pl/pgsql Limits In-Reply-To: <3A60976D.D683115C@mondo-live.com> from Najm Hashmi at "Jan 13, 2001 12:59:09 pm" To: Najm Hashmi Date: Sat, 13 Jan 2001 09:04:59 -0500 (EST) CC: "pgsql-sql@postgresql.org" , Tom Lane X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/125 X-Sequence-Number: 786 Najm Hashmi wrote: > Hi All, > As it is known that any funtion, written in pl/pgsql, can only > retrun one tuple. I am just wondering it were true as well for function > written in C language. I need to write few function that will retrun > mulitiple rows satsifying a certain set of conditions. Where I can get > some examples. > Tahnks in advance. > Najm Since the language handler is written in C, if it would've been possible (or make sense WRT the capabilities of the parser/planner/executor) I had done it for PL/pgSQL during initial creation of the language. We plan to tackle the problem for v7.2. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #