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/