Re: Recursive queries?

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Recursive queries?
Date: 2004-02-04 16:35:25
Message-ID: 1075912525.3122.32.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane kirjutas K, 04.02.2004 kell 06:04:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> > Wasn't there some guy at RedHat doing it?
>
> Andrew Overholt did some work on SQL99 recursive queries, but went back
> to university without having gotten to the point where it actually
> worked. One of the many things on my to-do list is to pick up and
> finish Andrew's work on this. If someone has time to work on it,
> let me know and I'll try to get what he had over to you.

I attach my early attempts at doing the same.

I also sent this to Andrew while he was working on it, and he claimed
that his version was similar. I think he sent me a slightly more
advanced verion of this, but I'm currently unable to lovcate it.

This has mainly the syntax part (without recursion control IIRC) and
some initial documentation (in python's StructuredText and html formats)

If I find Andrews variant I'll try to post it too.

-------------
Hannu

Attachment Content-Type Size
pg-with-recursive.tar.gz application/x-compressed-tar 21.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2004-02-04 16:36:38 Re: Recursive queries?
Previous Message Tom Lane 2004-02-04 15:48:22 Re: PITR Dead horse?