From: KuroiNeko <evpopkov@carrier.kiev.ua>
To: pgsql-sql@postgresql.org
Subject: Re: Re: Requests for Development
Date: Fri, 10 Nov 2000 10:00:50 +0000
Message-ID: <3A0BC752.nail1EE1D4VAA@ed.ed> (raw)
References: <Pine.LNX.4.21.0011100838310.7464-100000@wr-linux02.rki.de>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: evpopkov@carrier.kiev.ua
Subject: Re: Requests for Development
In-Reply-To: <3A0BC752.nail1EE1D4VAA@ed.ed>
References: <Pine.LNX.4.21.0011100838310.7464-100000@wr-linux02.rki.de> <3A0BC752.nail1EE1D4VAA@ed.ed>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox