On 16.01.02 10:38 +0000(+0000), John Taylor wrote:
>
> Hi,
>
> I'm having problems counting the number of distinct rows in a table.
>
> I've tried the following:
>
> select distinct on(id) count(id) from basketupdates order by id desc;
>
SELECT count(distinct id) FROM basketupdates;
see http://www.postgresql.org/idocs/index.php?sql-expressions.html
for more information.
- Einar Karttunen