Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group