Hi!
I think what you want to do is
SELECT Count( Distinct( cdusuario ) ) AS Cuenta FROM visitas;
:)
Regards.
João Paulo Ribeiro
Gonzalo A. Aranda Corral wrote:
>
> Someone of you can see where the sentence is wrong???
>
>SELECT Count(*) FROM (SELECT DISTINCT cdusuario FROM visitas) AS Cuenta;
>
>...
>parse error near select!!!
>
>
>:(
>
>Thanks for your help!!
>
>gum.
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/02
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
--
----------------------------------------------------------------------------
MobiComp - Mobile Computing & Wireless Solutions
phone: +351 253 305 250 fax: +351 253 305 251
web: http://www.mobicomp.com
----------------------------------------------------------------------------
