Thread: Count & Distinct

Search a lot of archives and have come up with very little (much old)

obviously

>>> select count(distinct(row)) from table;

Does not work so what is the work around? I have tried a bunch of stuff.

Thanks,
J

hhs=# select count(distinct(fieldorder)) from temp_fields;
 count
-------
     3

I just tried it really quick and it worked fine.. What are you getting with
what table/view and query?

-Mitch

----- Original Message -----
From: "J. Atwood" <jatwood@bwanazulia.com>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, August 23, 2000 3:45 PM
Subject: [GENERAL] Count & Distinct


> Search a lot of archives and have come up with very little (much old)
>
> obviously
>
> >>> select count(distinct(row)) from table;
>
> Does not work so what is the work around? I have tried a bunch of stuff.
>
> Thanks,
> J
>
>

"J. Atwood" <jatwood@bwanazulia.com> writes:
>>>> select count(distinct(row)) from table;

> Does not work so what is the work around? I have tried a bunch of stuff.

I bet you didn't try updating to 7.0?

            regards, tom lane

It works fine. Please try again




On Wed, 23 Aug 2000, J. Atwood wrote:

> Search a lot of archives and have come up with very little (much old)
>
> obviously
>
> >>> select count(distinct(row)) from table;
>
> Does not work so what is the work around? I have tried a bunch of stuff.
>
> Thanks,
> J
>
>