| From: | Brandon Metcalf <brandon(at)geronimoalloys(dot)com> |
|---|---|
| To: | "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: UNION question |
| Date: | 2009-07-10 16:33:50 |
| Message-ID: | Pine.LNX.4.58L.0907101133380.6574@cedar.geronimoalloys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
M == Matthew(dot)Hartman(at)krcc(dot)on(dot)ca writes:
M> > > From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
M> > > owner(at)postgresql(dot)org] On Behalf Of Brandon Metcalf
M> > > Sent: Friday, July 10, 2009 12:16 PM
M> >
M> > Change it to this:
M> Sorry, I forgot that you need to split the GROUP BY clause as well in a
M> similar manner to the WHERE clause. And unless you have duplicate rows
M> to eliminate, use UNION ALL rather than UNION for a speed increase.
Thanks. Got it to work.
--
Brandon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brandon Metcalf | 2009-07-10 16:34:48 | Re: UNION question |
| Previous Message | Tom Lane | 2009-07-10 16:29:00 | Re: UNION question |