Re: SINTAX ERROR!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gonzalo A(dot) Aranda Corral" <garanda(at)bitakora(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: SINTAX ERROR!!
Date: 2002-04-24 14:56:48
Message-ID: 12372.1019660208@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

"Gonzalo A. Aranda Corral" <garanda(at)bitakora(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message tony 2002-04-25 10:58:14 preparedStatement
Previous Message Dave Cramer 2002-04-24 13:25:59 Re: getArray Method()