M == Matthew.Hartman@krcc.on.ca writes:
M> > > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
M> > > owner@postgresql.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