Re: SINTAX ERROR!!

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
----------------------------------------------------------------------------