WITH/WITH RECURSIVE implementation discussion

Started by Mark Cave-Aylandover 19 years ago4 messages
#1Mark Cave-Ayland
m.cave-ayland@webbased.co.uk

Hi folks,

Looking ahead at some of the projects I'll be working on in the future, I'm
seeing that having an implementation of WITH/WITH RECURSIVE for working with
tree structures is going to be a very useful feature and so would like to
re-start the discussions on this to see whether this could be achieved for
PG 8.2.

The latest discussion I found related to this appears to be here:
http://archives.postgresql.org/pgsql-hackers/2005-11/msg00564.php which
indicates that Jonah is hoping to work on this for 8.2, but I don't see this
item as being worked on in the TODO list - does that mean that development
on this has halted?

Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk
http://www.infomapper.com
http://www.swtc.co.uk

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.

#2Jonah H. Harris
jonah.harris@gmail.com
In reply to: Mark Cave-Ayland (#1)
Re: WITH/WITH RECURSIVE implementation discussion

On 5/1/06, Mark Cave-Ayland <m.cave-ayland@webbased.co.uk> wrote:

The latest discussion I found related to this appears to be here:
http://archives.postgresql.org/pgsql-hackers/2005-11/msg00564.php which
indicates that Jonah is hoping to work on this for 8.2, but I don't see this
item as being worked on in the TODO list - does that mean that development
on this has halted?

No, in between all my other work here at EnterpriseDB, I'm still
working on it. I hope to get it submitted to -patches for review in
the next two weeks.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

#3Mark Cave-Ayland
m.cave-ayland@webbased.co.uk
In reply to: Jonah H. Harris (#2)
Re: WITH/WITH RECURSIVE implementation discussion

-----Original Message-----
From: Jonah H. Harris [mailto:jonah.harris@gmail.com]
Sent: 01 May 2006 14:56
To: Mark Cave-Ayland
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] WITH/WITH RECURSIVE implementation discussion

On 5/1/06, Mark Cave-Ayland <m.cave-ayland@webbased.co.uk> wrote:

The latest discussion I found related to this appears to be here:
http://archives.postgresql.org/pgsql-hackers/2005-11/msg00564.php which
indicates that Jonah is hoping to work on this for 8.2, but I don't see

this

item as being worked on in the TODO list - does that mean that

development

on this has halted?

No, in between all my other work here at EnterpriseDB, I'm still
working on it. I hope to get it submitted to -patches for review in
the next two weeks.

Hi Jonah,

That's great news. While I wouldn't say that I have intimate knowledge of
the PostgreSQL internals, I'd be happy to try and help you with this if time
is proving to be a problem.

Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk
http://www.infomapper.com
http://www.swtc.co.uk

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.

#4Jonah H. Harris
jonah.harris@gmail.com
In reply to: Mark Cave-Ayland (#3)
Re: WITH/WITH RECURSIVE implementation discussion

On 5/2/06, Mark Cave-Ayland <m.cave-ayland@webbased.co.uk> wrote:

That's great news. While I wouldn't say that I have intimate knowledge of
the PostgreSQL internals, I'd be happy to try and help you with this if time
is proving to be a problem.

Time is certainly an issue. After I post the patches, your assistance
would be really helpful in making any changes the community sees
necessary.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324