Re: Hierarchical Queries--Help!!!

Posted in 1996

Chris Drauch — 4 Sep 1996 03:58:25 -0400 — source: Informix-list mailing list archive (1991-1998)

Ashi Chaturvedula wrote > >Does Informix7.1 support hierarchical queries (similar to Oracle's >connect by clause)? As far as I know: NO. But Oracle's extensions are only providing partial support for tree structures. >For eg. I have a table that has records in it which >have parent/child/grandchild... upto n relationships stored. I need a >way to query the records and display it with appropriate indents. Difficult to handle with SQL. I would highest recommend to get Joe Celko's 'SQL for Smarties', published by Morgan Kaufmann. The whole chapter 26 is dedicated to the handling of trees. -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...