| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | James Orr <james(at)lrgmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Aasmund Midttun Godal <postgresql(at)envisity(dot)com> |
| Cc: | jeremy(at)wundt(dot)psychiatry(dot)uiowa(dot)edu, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: transposing data for a view |
| Date: | 2001-11-01 17:44:03 |
| Message-ID: | 20011101174403.43055.qmail@web20809.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
--- James Orr <james(at)lrgmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2001-11-01 18:08:52 | Re: How to use BYTEA type? |
| Previous Message | James Orr | 2001-11-01 17:16:38 | Aggregate binary AND |