Re: Count & Distinct

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