Re: Nested/recursive query execution

On Sat, Oct 22, 2005 at 03:41:07PM +0530, Paresh Bafna wrote:
> Hi all,
> I am new to postgres developement. Want some help.
> Can we run nested query in postgres?

The answer is yes, although you generally need to use the SPI interface
to do it. Among other things it sets up everything to work recursively.

Consider, foreign keys, SQL functions, etc are all recursive
invokations of a sort....

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.