Re: COUNT(Distinct city) HELP!!!

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(at)mohawksoft(dot)com>
> To: "Abe" <abe(at)fish(dot)tm>; "Hackers List" <pgsql-hackers(at)postgresql(dot)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