Re: select count of distinct rows

At 07:53 PM 12/10/05, Havasvölgyi Ottó wrote:
>I would like to select the count of distinct rows in a table.
> SELECT COUNT(DISTINCT *) FROM mytable;
>This does not work. How can I do it with Postgres?

select count(*) from (select distinct * from mytable) as x;