Re: [SQL] Counting the number of distinct rows returned

Drew,

Not really the answer you were asking, but in general, your
program will probably be using some interface other than
psql, i.e. libpq or Pg.pm, or whatever.

E.g. in C, if your PgQuery struct is pg1, then you
would do your query and retrieve the number of records
found with "pg1->PQntuples(pg1->reply)"




Troy


>
> How can I return the number of records (ie a count(user_id)) when using a
> statement like this:
>
> select distinct user_id from sales_by_region;
>
> I have tried things like:
>
> select count(distinct user_id) from sales_by_region (parse error)
> select distinct count(user_id) from sales_by_region (useless because count
> is performed before the distinct)
>
> HELP!
>
> Thanks,
>
> Drew
>
>
>
> ************
> Check out "PostgreSQL Wearables" @ http://www.pgsql.com
>
>