Re: SELECT too complex?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
Cc: Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SELECT too complex?
Date: 2003-06-29 19:25:49
Message-ID: 200306291225.49020.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Rory,

> However your analysis has made me think much more deeply about how the
> joins work and whether or not I need left outer joins. More than that,
> the difficulty I've had explaining the database structure to you means
> that I should carefully reconsider it.

Sure. Although sometimes a very good, well-normalized structure is impossible
to explain without a clearer diagram than you can do in ASCII -- and without
a clear understanding of what the database is for.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Hubert Lubaczewski 2003-06-30 11:12:36 Re: plpgsql rowtype
Previous Message Tom Lane 2003-06-28 02:54:09 Re: postmaster generates no socket