Skip site navigation (1) Skip section navigation (2)

Re: Counting Distinct Records

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Counting Distinct Records
Date: 2004-11-16 22:34:31
Message-ID: 20041116141911.K84773@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: 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.

In response to

Responses

pgsql-sql by date

Next:From: Thomas F.O'ConnellDate: 2004-11-16 23:02:56
Subject: Re: Counting Distinct Records
Previous:From: Andrew SullivanDate: 2004-11-16 22:09:37
Subject: Re: Move table between schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group