> 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
On Thu, 9 Nov 2000, Josh Berkus wrote:
> 2. Stored Procedure functionality, i.e. outputting a full recordset from
> a function (or new structure, if functions are hard to adapt) based on
> the last SELECT statement passed to the function. An alternative would
> be to develop parameterized views,
