X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Fgeneric-postgresql.lisp;h=55d3a9082b8c6984781a58ed84cd3aef8662c979;hb=4881f86240f3da99ae537238cfccd61ac9c91f8f;hp=af0ef61fabb0ff15a91f65792d33313771af8677;hpb=7308bdf188da6424e615ca14096ef53cfb845a90;p=clsql.git

diff --git a/sql/generic-postgresql.lisp b/sql/generic-postgresql.lisp
index af0ef61..55d3a90 100644
--- a/sql/generic-postgresql.lisp
+++ b/sql/generic-postgresql.lisp
@@ -27,25 +27,11 @@
   (declare (ignore type args database))
   "VARCHAR")
 
-(defmethod database-get-type-specifier ((type (eql 'simple-base-string)) args database
-					(db-type (eql :postgresql)))
-  (declare (ignore database))
-  (if args
-      (format nil "VARCHAR(~A)" (car args))
-      "VARCHAR"))
-
-(defmethod database-get-type-specifier ((type (eql 'simple-string)) args database
-					(db-type (eql :postgresql)))
-  (declare (ignore database))
-  (if args
-      (format nil "VARCHAR(~A)" (car args))
-      "VARCHAR"))
-
 (defmethod database-get-type-specifier ((type (eql 'string)) args database
 					(db-type (eql :postgresql)))
   (declare (ignore database))
   (if args
-      (format nil "VARCHAR(~A)" (car args))
+      (format nil "CHAR(~A)" (car args))
       "VARCHAR"))
 
 (defmethod database-get-type-specifier ((type (eql 'wall-time)) args database
@@ -227,3 +213,12 @@
            (sql-escape (string-downcase table)))
    database :auto nil))
 
+
+;; Capabilities
+
+(defmethod db-type-has-fancy-math? ((db-type (eql :postgresql)))
+  t)
+
+(defmethod db-type-default-case ((db-type (eql :postgresql)))
+  :lower)
+