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 hierarchical queries, a la Oracle > > > > 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 tree. But sorting such tree are very tricky (i > think). > > Patch allows result tree to be sorted, i.e. subnodes of each node will be > sorted by ORDER BY clause. > > with regards, evgen > > --- > .evgen > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
