Received: from web20809.mail.yahoo.com (web20809.mail.yahoo.com [216.136.226.198]) by postgresql.org (8.11.3/8.11.4) with SMTP id fA1Hi5P80558 for ; Thu, 1 Nov 2001 12:44:05 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011101174403.43055.qmail@web20809.mail.yahoo.com> Received: from [65.11.165.34] by web20809.mail.yahoo.com via HTTP; Thu, 01 Nov 2001 09:44:03 PST Date: Thu, 1 Nov 2001 09:44:03 -0800 (PST) From: Jeff Eckermann Subject: Re: transposing data for a view To: James Orr , Josh Berkus , Aasmund Midttun Godal Cc: jeremy@wundt.psychiatry.uiowa.edu, pgsql-sql@postgresql.org In-Reply-To: <007f01c162f5$d9a58ee0$1600000a@lrg.office> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/19 X-Sequence-Number: 5405 --- James Orr wrote: > I think he might be talking about mine. The region > values will not be > duplicated, the WHERE clause prevents it. If you are saying that I didn't read the original query closely enough, you're probably right. Unfortunately I deleted the original message, so I can't check that. > I kind of prefer my own query aesthetically, is it > as efficient internally? Someone more knowledgable will have to answer that: though I would guess that working with three joined tables would slow things down somewhat. > > - James > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com