Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3QEfV381216
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Apr 2001 10:41:32 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f3QEfMR15928;
	Thu, 26 Apr 2001 10:41:22 -0400 (EDT)
To: alexey@price.ru
cc: pgsql-interfaces@postgresql.org
Subject: Re: can external C-function get multiple rows? 
In-reply-to: <01042320014100.09239@workshop.price.ru> 
References: <01042320014100.09239@workshop.price.ru>
Comments: In-reply-to Alexey Nalbat <alexey@price.ru>
	message dated "Mon, 23 Apr 2001 19:35:22 +0400"
Date: Thu, 26 Apr 2001 10:41:21 -0400
Message-ID: <15925.988296081@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200104/118
X-Sequence-Number: 1502

Alexey Nalbat <alexey@price.ru> writes:
> So, can C-function return multiple rows?

In 7.1 it is possible to do this by using the new function-call
interface and adhering to the "functions returning sets" protocol
described in src/backend/utils/fmgr/README.

Before 7.1 there was no way --- the set-return support was a kluge
that only worked for SQL-language functions, not any other language.

			regards, tom lane