Re: Oracle: result type for count(*)

Edi Weitz <[email protected]> Wed, 12 Oct 2005 19:54:30 +0200
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
On Wed, 12 Oct 2005 11:18:23 -0600, Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> wrote:

> :result-types :auto means that CLSQL snarfs type information on each
> field from the database backend. I believe that Oracle is telling
> CLSQL that the result type is floating point. At least, when I was
> writing the backend support for Oracle, I noticed that it was giving
> me floating point results for operations that I'd suspect should
> have an integer result -- such as MAX(foo) where foo is an integer
> field.

OK, fair enough.  It's easy to wrap something like ROUND around it.  I
just wanted to double-check.

Thanks,
Edi.