InitializationUse
-(asdf:operate 'adsf:load-op 'clsql-postgresql)
+(asdf:operate 'asdf:load-op 'clsql-postgresql)
to load the PostgreSQL back-end. The database type for the
PostgreSQL back-end is :postgresql.
@@ -102,6 +102,9 @@
+ Notes
+ None.
+
@@ -203,6 +206,9 @@
+ Notes
+ None.
+
@@ -274,8 +280,85 @@
+ Notes
+ FDDL
+
+
+
+ drop-index
+ requires a table to be specified with the
+ :on keyword parameter.
+
+
+
+
+ views are not
+ supported by &mysql;.
+
+
+
+
+ The :transactions keyword argument to
+ create-table
+ controls whether or not the created table is an InnoDB
+ table which supports transactions.
+
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+ FDML
+
+
+
+ Prior to version 4.1, &mysql; does not support nested
+ subqueries in calls to select.
+
+
+
+
+ Symbolic SQL Syntax
+
+
+
+ &mysql; does not support the ||
+ concatenation operator. Use concat
+ instead.
+
+
+
+
+ &mysql; does not support the substr
+ operator. Use substring instead.
+
+
+
+
+ &mysql; does not support the
+ intersect and
+ except set operations.
+
+
+
+
+ &mysql; (version 4.0 and later) does not support string
+ table aliases unless the server is started with
+ ANSI_QUOTES enabled.
+
+
+
+
+
-
+
&odbc;
@@ -337,6 +420,18 @@
+ Notes
+ FDDL
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+
@@ -393,6 +488,11 @@
+ Notes
+
+ None.
+
+
@@ -432,6 +532,55 @@
+ Notes
+ Connection
+
+
+
+ Passing filename a value of
+ :memory: will create a database in
+ physical memory instead of using a file on disk.
+
+
+
+
+ Some operations will be many times faster if database
+ integrity checking is disabled by setting the SYNCHRONOUS
+ flag to OFF (see the SQLITE manual for details).
+
+
+
+
+ FDDL
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+ The :column-list keyword argument to
+ create-view
+ is not supported by &sqlite;.
+
+
+
+
+ Symbolic SQL Syntax
+
+
+
+ &sqlite; does not support the all,
+ some, any and
+ exists subquery operations.
+
+
+
+
+
@@ -470,7 +619,7 @@
global-name
- String representing the global name of the Orace database.
+ String representing the global name of the Oracle database.
This is looked up through the tnsnames.ora file.
@@ -491,6 +640,44 @@
+ Notes
+ Symbolic SQL Syntax
+
+
+
+ The userenv operator is &oracle; specific.
+
+
+
+
+ &oracle; does not support the except
+ operator. Use minus instead.
+
+
+
+
+ &oracle; does not support the all,
+ some, any
+ subquery operations.
+
+
+
+
+ Transactions
+
+
+
+ By default, &clsql; starts in transaction AUTOCOMMIT mode
+ (see set-autocommit).
+ To begin a transaction in autocommit mode, start-transaction
+ has to be called explicitly.
+
+
+
+
+