Re: [HACKERS] WITH support

2007-01-03 Thread Jonah H. Harris
On 1/3/07, David Fetter <[EMAIL PROTECTED]> wrote: As I recall, it was decided long ago, and the conclusions were: * Only BSD-compatibly licensed code goes in PostgreSQL's code base, * PostgreSQL will only support the SQL:2003 standard WITH (RECURSIVE) syntax in the main line code. Yes, see la

Re: [HACKERS] WITH support

2007-01-03 Thread David Fetter
On Wed, Jan 03, 2007 at 04:19:19PM -0700, Jonah H. Harris wrote: > On 1/3/07, Hubert FONGARNAND <[EMAIL PROTECTED]> wrote: > >Why not looking at http://gppl.moonbone.ru/ evgen potemkin. has > >ever made a patch for WITH and CONNECT BY? > > Nope, no good. This is what I started with last time and

Re: [HACKERS] WITH support

2007-01-03 Thread Jonah H. Harris
On 1/3/07, Mark Cave-Ayland <[EMAIL PROTECTED]> wrote: IIRC there were two issues - firstly the license for the patch was GPL as opposed to BSD used for PostgreSQL Yes, however Evgen was kind enough to grant me a BSD license for it should I get it committed into PostgreSQL. However, with the a

Re: [HACKERS] WITH support

2007-01-03 Thread Jonah H. Harris
On 1/3/07, Hubert FONGARNAND <[EMAIL PROTECTED]> wrote: Why not looking at http://gppl.moonbone.ru/ evgen potemkin. has ever made a patch for WITH and CONNECT BY? Nope, no good. This is what I started with last time and the refactoring attempt at WITH is just too massive. As for CONNECT BY, P

Re: [HACKERS] WITH support

2007-01-03 Thread Mark Cave-Ayland
On Wed, 2007-01-03 at 09:45 +0100, Hubert FONGARNAND wrote: > Why not looking at http://gppl.moonbone.ru/ evgen potemkin. has ever > made a patch for WITH and CONNECT BY? > > I'm ready to test these features... (RECURSIVE) when they'll land in > CVS... Hi Hubert, IIRC there were two issues - f

Re: [HACKERS] WITH support

2007-01-03 Thread Hubert FONGARNAND
Le mardi 02 janvier 2007 à 18:08 -0700, Jonah H. Harris a écrit : > On 12/30/06, Mark Cave-Ayland <[EMAIL PROTECTED]> wrote: > > In short, if people don't mind waiting for my free cycles to come along > > then I will continue to chip away at it; otherwise if it's considered an > > essential for 8.

Re: [HACKERS] WITH support

2007-01-02 Thread Jonah H. Harris
On 12/30/06, Mark Cave-Ayland <[EMAIL PROTECTED]> wrote: In short, if people don't mind waiting for my free cycles to come along then I will continue to chip away at it; otherwise if it's considered an essential for 8.3 with an April deadline then I will happily hand over to Jonah. I'd say it's

Re: [HACKERS] WITH support

2006-12-30 Thread Mark Cave-Ayland
On Sat, 2006-12-30 at 00:49 -0500, Jonah H. Harris wrote: > On 12/29/06, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > No code yet, and I don't remember who said they were working on it. > > I'm still waiting to hear from Mark Cave-Ayland on whether he's going > to pick it up or whether I'll just d

Re: [HACKERS] WITH support

2006-12-29 Thread Jonah H. Harris
On 12/29/06, Bruce Momjian <[EMAIL PROTECTED]> wrote: No code yet, and I don't remember who said they were working on it. I'm still waiting to hear from Mark Cave-Ayland on whether he's going to pick it up or whether I'll just do it. One way or another, there should be some movement regarding

Re: [HACKERS] WITH Support

2006-12-29 Thread Edwin S. Ramirez
The WITH that I am thinking about, lets you define and reuse queries which are executed once. For example: WITH MySummary AS (*SELECT b.dept_name, Sum(Salary) AS total_sal FROM emp a join dept b on (a.dept_id = b.dept_id) GROUP BY b.dept_name*) SELECT dept_name, total_sal //FROM MySumm

Re: [HACKERS] WITH support

2006-12-29 Thread Bruce Momjian
David Fetter wrote: > On Thu, Dec 28, 2006 at 10:52:45PM -0500, Bruce Momjian wrote: > > Edwin Ramirez wrote: > > > Hello, > > > > > > What is the status of supporting the "WITH" keyword? > > > > I see these TODO items: > > > > * Add SQL99 WITH clause to SELECT > > * Add SQL:2003 WITH RE

Re: [HACKERS] WITH support

2006-12-29 Thread David Fetter
On Thu, Dec 28, 2006 at 10:52:45PM -0500, Bruce Momjian wrote: > Edwin Ramirez wrote: > > Hello, > > > > What is the status of supporting the "WITH" keyword? > > I see these TODO items: > > * Add SQL99 WITH clause to SELECT > * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SE

Re: [HACKERS] WITH support

2006-12-29 Thread Hubert FONGARNAND
Hello, I can see : WITH RECURSIVE hierarchical queries (Jonah H. Harris) in : http://developer.postgresql.org/index.php/Todo:WishlistFor83 GREAT!!! Such feature is very important, because it is supported in most of commercial database SQL Server 2003 support WITH RECURSIVE DB2 support it too (

Re: [HACKERS] WITH support

2006-12-28 Thread Bruce Momjian
Edwin Ramirez wrote: > Hello, > > What is the status of supporting the "WITH" keyword? I see these TODO items: * Add SQL99 WITH clause to SELECT * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT Are they the same item? Someone has said they will do RECURSIVE for 8.

[HACKERS] WITH support

2006-12-28 Thread Edwin Ramirez
Hello, What is the status of supporting the "WITH" keyword? -- Edwin S. Ramirez, Senior Developer Information Technology Department - ITDC Mount Sinai Medical Center [EMAIL PROTECTED] * 646-217-3112 ---(end of broadcast)--- TIP 2: Don't 'kill -9'