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.