From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "J(dot) Atwood" <jatwood(at)bwanazulia(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Count & Distinct |
Date: | 2000-08-23 23:31:37 |
Message-ID: | 002501c00d5a$48a8be90$0200000a@doot |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)bwanazulia(dot)com>
To: <pgsql-general(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | richard excite | 2000-08-24 02:10:48 | 2-phase commit |
Previous Message | J. Atwood | 2000-08-23 22:45:48 | Count & Distinct |