Received: from snoopy.mohawksoft.com ([216.41.12.227])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBQ2afL93041
	for <pgsql-hackers@postgresql.org>;
	Mon, 25 Dec 2000 21:36:41 -0500 (EST)
	(envelope-from markw@mohawksoft.com)
Received: from mohawksoft.com (IDENT:markw@snoopy.mohawksoft.com
	[216.41.12.227])
	by snoopy.mohawksoft.com (8.11.0/8.11.0) with ESMTP id eBQ2dlF14563;
	Mon, 25 Dec 2000 21:39:47 -0500
Message-ID: <3A4804F3.F61D0C48@mohawksoft.com>
Date: Mon, 25 Dec 2000 21:39:47 -0500
From: mlw <markw@mohawksoft.com>
X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16-Mohawk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Abe <abe@fish.tm>
CC: Hackers List <pgsql-hackers@postgresql.org>
Subject: Re: COUNT(Distinct city) HELP!!!
References: <001001c06ec8$36bec380$6500a8c0@win2k>
	<3A47D6E7.E85FACDE@mohawksoft.com>
	<002e01c06ee5$6abe5ac0$6500a8c0@win2k>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200012/993
X-Sequence-Number: 2522

Abe wrote:
> 
> Hey there,
> 
> Just tried that - No luck - I am using version 6.5.0 - Maybe its just not
> available in this version.
> Any alternatives ?

I have tried this on version 7.02. I assume 6.5 did not support it.

> 
> 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
> >

-- 
http://www.mohawksoft.com