Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2808Sx91490 for ; Wed, 7 Mar 2001 19:08:28 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2808D919635; Wed, 7 Mar 2001 19:08:13 -0500 (EST) To: Kyle cc: pgsql-sql@postgresql.org Subject: Re: A query that doesn't work on 7.1 In-reply-to: <3AA6C0AD.BC8A015A@actarg.com> References: <3AA6C0AD.BC8A015A@actarg.com> Comments: In-reply-to Kyle message dated "Wed, 07 Mar 2001 16:13:50 -0700" Date: Wed, 07 Mar 2001 19:08:13 -0500 Message-ID: <19632.984010093@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/164 X-Sequence-Number: 1817 Kyle writes: > Here's a query that doesn't work on 7.1. Is this a bug or am I doing > something wrong? Hmm, I think you have found some subtle bugs in aggregate processing; offhand it seems like both these queries should be legal. I'll see what I can do about it. regards, tom lane