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.