Re: 'select count...' returns SQL_VARCHAR?

Tom Lane wrote:
> Stelios Sfakianakis <ssfak@ics.forth.gr> writes:
>
>>I am using the PostgreSQL and its ODBC driver but there seems to be
>>some problem with the "select count(...)..." queries. Here is my
>>configuration:
>>  - FreeBSD 4.6
>>  - PostgreSQL 7.2.1
>
>
> count() returns bigint (int8) in 7.2.  I seem to recall that ODBC has
> some problem classifying bigint as numeric.  I don't recall if that's
> a simple bug or a standards compatibility issue.  Anyway, the easiest
> workaround may be to cast the result of count to integer (int4) so that
> ODBC knows what to do with it.
>
>             regards, tom lane

It works as expected, of course!
Thank you very much!

Best regards
Stelios Sfakianakis

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly



--
"Right now, CORBA *is* the future of middleware. I'm not aware of any
other middleware that would come even close in portability, platform
support, features, performance, or multi-vendor support. It will be a
minimum of six or seven years before any other middleware platform
will be able to match that."
       --- Michi Henning in news:comp.object.corba, 28/06/2002