Re: [HACKERS] Schema boggle...

Chris,

>   Monolithic tables have their uses, I don't and wont contest that, however
> we've been using a monolithic structure in our current AMS distribution and
<snip>
> dataset. That and I'm more confident working on a 3D level, versus 2D, the
> schema levels introduce the third dimension into my structure and simplify
> visualizing how I want things to work.

TMI!  TMI!  Ok, I believe that it works for you.   You've made a tradeoff, 
though, and some operations that were simple in the old monolithic structure 
will now be more difficult -- however worthwhile the overall tradeoff may be.

> resulting query as he suggested, I just need to learn plpgsql programming
> so that I can work out all of the details (Tom, I might bug you about that
> once in a while).

Just go ahead and post your PL/pgSQL questions to the list.  There are people 
on this list who've written thousands of lines of PL/pgSQL ...

-- 
Josh Berkus
Aglio Database Solutions
San Francisco