Re: [HACKERS] Proposal of hierachical queries (a la Oracle)

2002-11-16 Thread Evgen Potemkin
Ok, full section would be very helpful, i don't have it. --- .evgen On 15 Nov 2002, Rod Taylor wrote: > On Thu, 2002-11-14 at 06:52, Evgen Potemkin wrote: > > Hi there! > > > > I want to propose the patch for adding the hierarchical queries posibility. > > It allows to construct queries a la Ora

Re: [HACKERS] Proposal of hierachical queries (a la Oracle)

2002-11-15 Thread Rod Taylor
On Thu, 2002-11-14 at 06:52, Evgen Potemkin wrote: > Hi there! > > I want to propose the patch for adding the hierarchical queries posibility. > It allows to construct queries a la Oracle for ex: > SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;B Great addition. But please use the SQL 99

[HACKERS] Proposal of hierachical queries (a la Oracle)

2002-11-15 Thread Evgen Potemkin
Hi there! I want to propose the patch for adding the hierarchical queries posibility. It allows to construct queries a la Oracle for ex: SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;B I've seen this type of queries often made by adding a new type, which stores position of row in the tre