Received: from biology.nmsu.edu (biology.NMSU.Edu [128.123.5.72]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA79658 for ; Fri, 21 Jan 2000 12:00:41 -0500 (EST) (envelope-from brook@biology.nmsu.edu) Received: (from brook@localhost) by biology.nmsu.edu (8.8.8/8.8.8) id KAA25292; Fri, 21 Jan 2000 10:00:40 -0700 (MST) Date: Fri, 21 Jan 2000 10:00:40 -0700 (MST) Message-Id: <200001211700.KAA25292@biology.nmsu.edu> X-Authentication-Warning: biology.nmsu.edu: brook set sender to brook@biology.nmsu.edu using -f From: Brook Milligan To: pgsql-sql@postgreSQL.org Subject: DISTINCT and aggregates It seems (in 6.5.2) that one cannot execute queries like: select count (distinct foo) from bar; Am I doing something silly or is this really not supported? Is there any workaround? Is this a TODO item? Cheers, Brook