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

I believe that functionality was added in version 7.0,
are you using an earlier version?

On Mon, 25 Dec 2000, Abe wrote:

On Mon, Dec 25, 2000 at 11:12:50PM -0000, some SMTP stream spewed forth:

Hey there,

I get this error but I think this is supposed to work:

Hrm, it works here on 7.0.2 where each field is "text".

=> select version();
version
-----------------------------------------------------------------
PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0, compiled by cc
(1 row)

I wish that I could actually *help* you, but I can not. ;-(

G'luck.

gh

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

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

or u can also try

select count(*)
from
(select distinct city from ct);

Hope this helps
Anand

No Joy,
unfortunately - It may well be time to upgrade.

Thanks,
Abe

----- Original Message -----
From: "Anand Raman" <araman@india-today.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, December 26, 2000 6:43 AM
Subject: Re: [GENERAL] COUNT(Distinct city) HELP!!!

or u can also try

select count(*)
from
(select distinct city from ct);

Hope this helps
Anand

On Mon, Dec 25, 2000 at 05:27:30PM -0800, Stephan Szabo wrote:

I believe that functionality was added in version 7.0,
are you using an earlier version?

On Mon, 25 Dec 2000, Abe wrote:

Hey there,

I get this error but I think this is supposed to work:

The table has some duplicates such as Munich I want the number of

distinct cities: