pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (15+ messages)  latest in thread

Message-ID: <3A0BC752.nail1EE1D4VAA@ed.ed>
Permalink:  ../3A0BC752.nail1EE1D4VAA@ed.ed/
Also on:    postgresql.org/message-id/3A0BC752.nail1EE1D4VAA@ed.ed

 · 

reply

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