| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Paresh Bafna <paresh(at)it(dot)iitb(dot)ac(dot)in> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Nested/recursive query execution |
| Date: | 2005-10-22 10:22:54 |
| Message-ID: | 20051022102253.GC16589@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-10-22 10:53:36 | Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance |
| Previous Message | Martijn van Oosterhout | 2005-10-22 10:12:38 | Re: Question about Ctrl-C and less |