Oracle: result type for count(*)

Edi Weitz <[email protected]> Wed, 12 Oct 2005 18:25:24 +0200

Newsgroups	gmane.lisp.clsql.devel
Message-ID	<[email protected]>

Hi!

With an Oracle 10g database (and LWW 4.4.5 if that matters) I get the
following:

  CL-USER 5 > (query "select count(*) from class_table" :result-types :auto)
  ((858.0))
  ("COUNT(*)")

I would have expected an integer as the result (and that's what I seem
to get with other databases).

Cheers,
Edi.