in reply to Architectural question...

it looks like you are doing strange joins with the SQL. rather than using strange-and-wonderful postgres specific functions, i would re-evaluate the design of the database....as from a cursory glance at the sql, you seem to be doing things of a hierarchial/recursive nature. not something relational databases are designed for.
the hardest line to type correctly is: stty erase ^H

Replies are listed 'Best First'.
Re^2: Architectural question...
by devnul (Monk) on Jul 07, 2005 at 22:43 UTC
    Dealing with heirarchal data is precisely what ltree was designed to do (using GiST indexes).

    I do tend to agree that this is not ideally done in a relational database, which is the purpose of this post. I'm trying to find a different/better solution but so far am coming up empty. :(

    - dEvNuL
[reply]

In Section Seekers of Perl Wisdom