Re: transposing data for a view - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: transposing data for a view
Date
Msg-id 20011101174403.43055.qmail@web20809.mail.yahoo.com
Whole thread Raw
In response to Re: transposing data for a view  ("James Orr" <james@lrgmail.com>)
List pgsql-sql
--- James Orr <james@lrgmail.com> 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


pgsql-sql by date:

Previous
From: "James Orr"
Date:
Subject: Aggregate binary AND
Next
From: Philip Hallstrom
Date:
Subject: Re: Aggregate binary AND