| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | Ellen Cyran <ellen(at)urban(dot)csuohio(dot)edu> |
| Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Function to Pivot data |
| Date: | 2002-01-31 21:05:24 |
| Message-ID: | 20020131160524.V2485@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 31, 2002 at 03:51:09PM -0500, Ellen Cyran wrote:
> I've run the SQL statement below and it doesn't give me
> what I thought and even gives me some incorrect data.
> Any idea why?
You're getting the Cartesian product. No, I don't know why, but it
looks like the query I suggested doesn't work well. Someone else
(who is better than I am) will likely see it.
A
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-01-31 21:06:27 | Re: going crazy with serial type |
| Previous Message | Gregory Wood | 2002-01-31 21:04:22 | Re: going crazy with serial type |