Received: from cmailg7.svr.pol.co.uk (cmailg7.svr.pol.co.uk [195.92.195.177])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBQ2YEL92890
	for <pgsql-hackers@postgresql.org>;
	Mon, 25 Dec 2000 21:34:14 -0500 (EST) (envelope-from abe@fish.tm)
Received: from [195.92.67.23] (helo=mail18.svr.pol.co.uk)
	by cmailg7.svr.pol.co.uk with esmtp (Exim 3.13 #0)
	id 14Ajwg-0006l5-00; Tue, 26 Dec 2000 02:34:34 +0000
Received: from modem-26.foxface.dialup.pol.co.uk ([62.137.15.26] helo=win2k)
	by mail18.svr.pol.co.uk with smtp (Exim 3.13 #0)
	id 14Ajwe-0001Yw-00; Tue, 26 Dec 2000 02:34:33 +0000
Message-ID: <002e01c06ee5$6abe5ac0$6500a8c0@win2k>
From: "Abe" <abe@fish.tm>
To: "mlw" <markw@mohawksoft.com>,
 "Hackers List" <pgsql-hackers@postgresql.org>
References: <001001c06ec8$36bec380$6500a8c0@win2k>
	<3A47D6E7.E85FACDE@mohawksoft.com>
Subject: Re: COUNT(Distinct city) HELP!!!
Date: Tue, 26 Dec 2000 02:41:56 -0000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Archive-Number: 200012/992
X-Sequence-Number: 2521

Hey there,

Just tried that - No luck - I am using version 6.5.0 - Maybe its just not
available in this version.
Any alternatives ?

Thanks Guys,
Abe
----- Original Message -----
From: "mlw" <markw@mohawksoft.com>
To: "Abe" <abe@fish.tm>; "Hackers List" <pgsql-hackers@postgresql.org>
Sent: Monday, December 25, 2000 11:23 PM
Subject: Re: COUNT(Distinct city) HELP!!!


> Abe wrote:
> >
> >    Part 1.1    Type: Plain Text (text/plain)
> >            Encoding: quoted-printable
>
> Try this:
> select count(distinct (city) ) from ct
> --
> http://www.mohawksoft.com
>