Re: Re: Trouble with floats in Postgresql

Friedrich Dominicus <[email protected]> Mon, 08 May 2006 08:49:52 +0200
Newsgroups gmane.lisp.clsql.devel
Organization Q Software Solutions GmbH
Message-ID <[email protected]>
>>
>> Just as another data point, I can't reproduce this bug with CLSQL
>> 3.5.7 and Postgresql 8.0.7 (SBCL 0.9.12, linux/x86).

Here the results of my try with 3.5.7, Postgresql 8.1.x 
SBCL 0.9.12.5 (Debian AMD64 unstable)
DB> (def-view-class t1 ()
      ((val :type float :accessor val)))
#<CLSQL-SYS::STANDARD-DB-CLASS T1>

DB> (defun test-t1 ()
      (drop-table 't1)
      (create-view-from-class 't1)
      (let ((obj (make-instance 't1)))
        (setf (val obj) 0.07)
        (update-records-from-instance obj)
        (let ((fobj (car (select 't1 :flatp t))))
          (val fobj))))
TEST-T1
DB> (test-t1)
0.0d0

Regards
Friedrich