> PL/pgSQL parses the entire function body at first call (per
> backend). But the SPI querystrings for all the statements
> aren't parsed at that time. It uses SPI_prepare() only for
> expressions and queries that actually get executed, so that a
> huge function that is called
KuroiNeko wrote:
> > 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
> 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