Re: SINTAX ERROR!! - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: SINTAX ERROR!!
Date
Msg-id 12372.1019660208@sss.pgh.pa.us
Whole thread Raw
In response to SINTAX ERROR!!  ("Gonzalo A. Aranda Corral" <garanda@bitakora.com>)
List pgsql-jdbc
"Gonzalo A. Aranda Corral" <garanda@bitakora.com> writes:
>     Someone of you can see where the sentence is wrong???

> SELECT Count(*) FROM (SELECT DISTINCT cdusuario FROM visitas) AS Cuenta;

It's not wrong (though as others have pointed out, there are other
ways to do it).  How old is your Postgres?  This should work in 7.1
or later.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: getArray Method()
Next
From: tony
Date:
Subject: preparedStatement