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 NAA10765 for ; Fri, 21 Jan 2000 13:38:17 -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 NAA16400; Fri, 21 Jan 2000 13:38:11 -0500 (EST) To: Brook Milligan cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] DISTINCT and aggregates In-reply-to: <200001211700.KAA25292@biology.nmsu.edu> References: <200001211700.KAA25292@biology.nmsu.edu> Comments: In-reply-to Brook Milligan message dated "Fri, 21 Jan 2000 10:00:40 -0700" Date: Fri, 21 Jan 2000 13:38:10 -0500 Message-ID: <16397.948479890@sss.pgh.pa.us> From: Tom Lane Brook Milligan writes: > It seems (in 6.5.2) that one cannot execute queries like: > select count (distinct foo) from bar; Right. It's implemented for 7.0... regards, tom lane