Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA71471 for ; Tue, 25 Jan 2000 03:22:33 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id DAA12874; Tue, 25 Jan 2000 03:20:20 -0500 (EST) To: Philip Warner cc: Don Baccus , Chris Bitmead , pgsql-hackers@postgreSQL.org Subject: Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace In-reply-to: <3.0.5.32.20000125185459.00cf7450@mail.rhyme.com.au> References: <3.0.5.32.20000125170026.0357d8f0@mail.rhyme.com.au> <11879.948776470@sss.pgh.pa.us> <3.0.5.32.20000125150557.036121c0@mail.rhyme.com.au> <2295.948765015@sss.pgh.pa.us> <3.0.5.32.20000125140349.035768d0@mail.rhyme.com.au> <3.0.5.32.20000125150557.036121c0@mail.rhyme.com.au> <3.0.5.32.20000125170026.0357d8f0@mail.rhyme.com.au> <3.0.5.32.20000125185459.00cf7450@mail.rhyme.com.au> Comments: In-reply-to Philip Warner message dated "Tue, 25 Jan 2000 18:54:59 +1100" Date: Tue, 25 Jan 2000 03:20:20 -0500 Message-ID: <12871.948788420@sss.pgh.pa.us> From: Tom Lane Philip Warner writes: > Thanks, but now I'm confused. I would have thought that aggregates went > *before* the having clause, Arrgh. You are right of course. Shouldn't pontificate late at night... regards, tom lane