Re: SQL question on hierarchical data

Scott Gray wrote:
>
> In comp.databases.sybase gus <gus_goose_at_hotmail.com> wrote:
> : eric__hogue_at_my-dejanews.com wrote:
> :>
> :> In article <HwAS1.2910$yo1.55067256_at_news.ipass.net>,
> :> "David Sisk" <davesisk_at_ipass.net> wrote:
> :> > Sunil Godithi wrote in message ...
> :> > >hi,

 [snip]
>
> Ack! Evil iterative processing! :) Yes...there is another way.
>
> Check out:
>
> http://reality.sgi.com/pablo/Sybase_FAQ/Q7.7.html
>
> this is a write-up I did (although the algo isn't mine) a year or
> two ago on a relatively elegant (and extremely efficient) way in
> which transitive closure statements can be achieved. I have
> successfully used this algorithm in a very complex environment
> with arbitrary depth, staggered hierarchies. The major drawback
> of the algo, however, is that it is very processing intensive on
> altering the structure of the hierarchy (i.e. if your hierarchical
> structure changes by the second, then it is probably not the
> solution for you).
>
> -scott
>
> --
> Scott C. Gray gray_at_voicenet.com "my keybard is brken"
> Sybase Professional Services scott.gray_at_sybase.com
> http://www.voicenet.com/~gray/sqsh.html

I will have a look ;-)

cheers
gus Received on Wed Oct 14 1998 - 00:00:00 CDT