Re: My troubles with test PostgreSQL 8.1

Yaroslav Kavenchuk <[email protected]> Fri, 11 Nov 2005 14:52:47 +0200
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Thanks!

One more question:

insert double-float data:

[7]> (clsql:execute-command
"create table test (id integer, n decimal(15,3) default 0)"
:database db)

[8]> (clsql:insert-records :database db :into "test" :values '(1 1.5))

[9]> (clsql:insert-records :database db :into "test" :values '(1 1.5d1))
*** - While accessing database #<POSTGRESQL-DATABASE
localhost/test/postgres OPEN #x19FC6AA5>
      with expression "INSERT INTO test VALUES (1,15.0d0)":
      Error 7 / syntax error at or near "d0" at character 32
      has occurred.

oops. How?
(coerce value 'single-float) may be incorrect (especialy if value is
long-float).

Thanks.

-- 
WBR, Yaroslav Kavenchuk.