Re: Nested/recursive query execution - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Nested/recursive query execution
Date
Msg-id 20051022102253.GC16589@svana.org
Whole thread Raw
In response to Nested/recursive query execution  (Paresh Bafna <paresh@it.iitb.ac.in>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Question about Ctrl-C and less
Next
From: "Magnus Hagander"
Date:
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance