Received: from sivka.carrier.kiev.ua (sivka.carrier.kiev.ua [193.193.193.101]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAAA3os11253 for ; Fri, 10 Nov 2000 05:03:50 -0500 (EST) (envelope-from evpopkov@carrier.kiev.ua) Received: from planka.carrier.kiev.ua (root@users.lucky.net [193.193.193.106]) by sivka.carrier.kiev.ua (8/Kilkenny_is_better) with ESMTP id MBB44690 for ; Fri, 10 Nov 2000 12:02:42 +0200 (EET) (envelope-from evpopkov@carrier.kiev.ua) Received: from ed.ed (ln2-139.users.lucky.net [193.193.199.139]) by planka.carrier.kiev.ua (8) with ESMTP id MBA36046 for ; Fri, 10 Nov 2000 12:02:39 +0200 (EET) (envelope-from evpopkov@carrier.kiev.ua) Received: (from root@localhost) by ed.ed (8.8.7/8.8.5) id KAA01837 for pgsql-sql@postgresql.org; Fri, 10 Nov 2000 10:00:50 GMT From: KuroiNeko Date: Fri, 10 Nov 2000 10:00:50 +0000 To: pgsql-sql@postgresql.org Subject: Re: Re: Requests for Development Message-ID: <3A0BC752.nail1EE1D4VAA@ed.ed> References: User-Agent: nail 9.14 2000-06-26 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/83 X-Sequence-Number: 114 > I wonder if there couldn't borrowed some code from Interbase which has > full featured stored procedures - at least it was told to me that it has > ... Well, I have some hands-on experience with IB, don't know whether this is perfectly relevant, but here goes.... Indeed, stored procedures in IB can do what's called `returning record sets' in this thread. This is helpfull when tuples restriction is based upon condition that is not easy/possible to formulate in SQL (where clause). On the other hand, IB has two different ways to call an SP: execute procedure for `singleton' SPs and select for those returning multiple tuples. However, IB supports only its own SP language. It's pretty much complete and well thought and implemented, but if you want an SP in PERL, you're out of luck. What I'd really like to see is `pre-compiled' SPs in PGSQL. IB has this feature (SPs are converted to BLR when DDL statement is executed), not sure about PGSQL. I've noticed that language-specific errors in SPs are only reported by PGSQL when SP is executed, so I suggest that interpreter (eg for PL/PGSQL) is called each time. -- Sniper's rifle is an extension of his eye. He kills with his injurious vision. JM