Re: Re: Requests for Development

> 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