Postgres Pro
Downloads
Home   >   mailing lists

DISTINCT and aggregates - Mailing list pgsql-sql

From Brook Milligan
Subject DISTINCT and aggregates
Date
Msg-id 200001211700.KAA25292@biology.nmsu.edu
Whole thread Raw
Responses Re: [SQL] DISTINCT and aggregates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
It seems (in 6.5.2) that one cannot execute queries like:
  select count (distinct foo) from bar;

Am I doing something silly or is this really not supported?

Is there any workaround?  Is this a TODO item?

Cheers,
Brook

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Duplicate tuples with unique index
Next
From: "Neil Cameron"
Date:
Subject: SQL Things