NUMBER -> NUMERIC for postgresql
Aleksandar Bakic <a_bakic-/[email protected]> Wed, 12 Oct 2005 09:11:08 -0700 (PDT)
| Newsgroups | gmane.lisp.clsql.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi,
It seems the following should be added to sql/generic-postgresql.lisp:
(defmethod database-get-type-specifier ((type (eql 'number)) args database
(db-type (eql :postgresql)))
(declare (ignore database db-type))
(cond
((and (consp args) (= (length args) 2))
(format nil "NUMERIC(~D,~D)" (first args) (second args)))
((and (consp args) (= (length args) 1))
(format nil "NUMERIC(~D)" (first args)))
(t
"NUMERIC")))
Alex
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/