Re: [HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-28 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > On Thu, 2002-11-28 at 17:34, Evgen Potemkin wrote: >> understanding SQL99 draft is a bit more difficult than i thought :) > You might also try to get DB2 installed somewhere (IIRC IBM gives out > limited time developer copies). Even without DB2 install

Re: [HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-28 Thread Hannu Krosing
On Thu, 2002-11-28 at 17:34, Evgen Potemkin wrote: > thanks, it's VERY helpful. > understanding SQL99 draft is a bit more difficult than i thought :) You might also try to get DB2 installed somewhere (IIRC IBM gives out limited time developer copies). It implements at least the basic recursive q

Re: [HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-28 Thread Evgen Potemkin
thanks, it's VERY helpful. understanding SQL99 draft is a bit more difficult than i thought :) regards, --- .evgen On 27 Nov 2002, Hannu Krosing wrote: > I attach a railroad diagram of SQL99 "WITH RECURSIVE" and a diff against > mid-summer gram.y which implements half of SQL99 _syntax_ (just th

Re: [HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-26 Thread Hannu Krosing
Evgen Potemkin kirjutas R, 22.11.2002 kell 15:57: > Hi there! > > Patch is posted to pgsql-patches. docs inside. It would of course be nice to support both Oracle and ISO/ANSI syntaxes, but I'm afraid that the (+) may clash with our overloadable operators feature. > SQL 99 version will be later.

[HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-26 Thread Evgen Potemkin
Hi there! Patch is posted to pgsql-patches. docs inside. SQL 99 version will be later. regards, --- .evgen ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster