Re: [HACKERS] Proposal of hierarchical queries, a la Oracle

2002-11-17 Thread Christopher Kings-Lynne
Was there supposed to be a patch attached to this email? Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Evgen Potemkin > Sent: Friday, 15 November 2002 5:38 PM > To: [EMAIL PROTECTED] > Subject: [HACKERS] Proposal of hiera

[HACKERS] Proposal of hierarchical 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 tr