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
In response to
pgsql-sql by date
|Next:||From: Thomas F.O'Connell||Date: 2004-11-16 23:02:56|
|Subject: Re: Counting Distinct Records|
|Previous:||From: Andrew Sullivan||Date: 2004-11-16 22:09:37|
|Subject: Re: Move table between schemas|