Re: Counting Distinct Records - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Counting Distinct Records
Date
Msg-id 20041116141911.K84773@megazone.bigpanda.com
Whole thread Raw
In response to Re: Counting Distinct Records  (Thomas F.O'Connell <tfo@sitening.com>)
Responses Re: Counting Distinct Records
List pgsql-sql
On Tue, 16 Nov 2004, Thomas F.O'Connell wrote:

> Is there another way to accomplish what the former is doing, then?

The only thing I can think of is a subselect in from that uses distinct.select count(*) from (select distinct ...) foo

That also theoretically allows you to use select distinct * inside the
subselect.


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Move table between schemas
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Counting Distinct Records