X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=base%2Fdb-interface.lisp;h=64a15c59da3b11f7a95bbffed48fa32ad8c2c4fe;hb=42cc1228e98bd1333c0f67c944f3aa0e07ba248f;hp=9591c9c488495970b06952b87767c692a74e830d;hpb=23b76563b25a517ad20f29d6dc5a65c8b958a042;p=clsql.git

diff --git a/base/db-interface.lisp b/base/db-interface.lisp
index 9591c9c..64a15c5 100644
--- a/base/db-interface.lisp
+++ b/base/db-interface.lisp
@@ -224,6 +224,19 @@ the given lisp type and parameters."))
 	   t)
   (:documentation "T [default] if database-type supports views."))
 
+(defgeneric db-type-default-case (db-type)
+  (:method (db-type)
+	   (declare (ignore db-type))
+	   ;; By default, CommonSQL converts identifiers to UPPER case. 
+	   :upper)
+  (:documentation ":upper [default] if means identifiers mapped to UPPER case SQL like CommonSQL API. However, Postgresql maps identifiers to lower case, so PostgreSQL uses a value of :lower for this result."))
+
+(defgeneric db-type-has-fancy-math? (db-type)
+  (:method (db-type)
+	   (declare (ignore db-type))
+	   nil)
+  (:documentation "NIL [default] if database-type does not have fancy math."))
+
 (defgeneric db-type-has-subqueries? (db-type)
   (:method (db-type)
 	   (declare (ignore db-type))
@@ -233,7 +246,7 @@ the given lisp type and parameters."))
 (defgeneric db-type-has-boolean-where? (db-type)
   (:method (db-type)
 	   (declare (ignore db-type))
-	   ;; SQL92 has boolean where
+	   ;; SQL99 has boolean where
 	   t)
   (:documentation "T [default] if database-type supports boolean WHERE clause, such as 'WHERE MARRIED'."))