Ian Lance Taylor <ian(at)airs(dot)com> writes:
> Does the SPI interface support recursion?  That is, can a function
> use SPI to make a query which involves calling another function which
> uses SPI?

Looks to me like it should work.

> The documentation suggests not, saying that if a function which uses
> SPI calls another function which uses SPI, it won't work, and calling
> that ``bad practice.''

The documentation could be out of date.  Why don't you test it out and
let us know?

			regards, tom lane

In response to

• Recursion and SPI at 2001-01-05 19:39:16 from Ian Lance Taylor

pgsql-hackers by date

Next:	From: Alex Pilosov	Date: 2001-01-05 23:06:55
	Subject: Re: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)
Previous:	From: Tom Lane	Date: 2001-01-05 23:01:48
	Subject: Re: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)