Re: Joins with aggregate data

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: paul(at)paulmcgarry(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Joins with aggregate data
Date: 2005-07-08 03:55:05
Message-ID: 20050708035505.GA56081@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 08, 2005 at 01:37:54PM +1000, Paul McGarry wrote:
>
> Thank you Michael, your suggestion works a charm (though I didn't
> bother coalescing the two grp because I think the USING takes care of
> that anyway.

Oops, yeah -- I had started with "ON b.grp = g.grp" but changed it
to "USING (grp)" and neglected to get rid of that coalesce.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2005-07-08 04:23:45 mail change for list?
Previous Message Tom Lane 2005-07-08 03:52:49 Re: index bloat