M == matthew.hart...@krcc.on.ca writes: M> > > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- M> > > ow...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
