DISTINCT and aggregates

From: Brook Milligan <brook(at)biology(dot)nmsu(dot)edu>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: DISTINCT and aggregates
Date: 2000-01-21 17:00:40
Message-ID: 200001211700.KAA25292@biology.nmsu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tibor Laszlo 2000-01-21 17:59:42
Previous Message Tibor Laszlo 2000-01-21 16:53:32 psql - odbc - bde - data dictionary