Re: Count & Distinct

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: Whole Thread | Raw Message | 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
>
>

In response to

Browse pgsql-general by date

  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