Am Donnerstag, 09. Aug 2007, 20:44:21 -0400 schrieb Andrew Dunstan:
> Bertram Scharpf wrote:
> >Am Mittwoch, 08. Aug 2007, 14:04:23 +0200 schrieb Bertram Scharpf:
> >>Am Mittwoch, 08. Aug 2007, 00:52:41 +0200 schrieb Bertram Scharpf:
> >>    
> >>>  <http://www.bertram-scharpf.de/tmp/connectby.tar.gz>
> >>>      
> >
> >Nobody's answering just a line. Is it such a bore?
> Isn't connect by the Oracle non-standard way of doing recursive queries? 
> Please review the mailing list archives on this subject.

I sure spent more time and effort on googling for
"recursive" and "hierarchical" than on writing it myself in
the end.

My solution has two features you probably will not find in
any Postgres or other SQL implementation.

  - Inverse lookup. Instead of descending down the tassel
    the path leading to the requested element is shown.

  - A boolean field that indicates whether we have reached
    the last element of a node. This is useful when drawing
    a tree; you can give a ` instead of a | in front of the

      | Bart     false
      | Lisa     false
      ` Maggie   true

    It takes almost no cost in time and memory.

> Also, many people have their heads down trying to punch out a release, 
> right now.

Wouldn't the release be a good opportunity for providing
this little tool?

Thanks for your answers.


Bertram Scharpf
Stuttgart, Deutschland/Germany

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to