X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-syntax.xml;h=787b4a3b08b28d1c09672447ad171a28e7286984;hb=0817beb5857835cfe68867e7026161f356869bdf;hp=e0e091eb77f741fe2a0a278907a07f3a12b499bc;hpb=528064c179b6b74f0a9d6a43c42e71de3f0e9a3a;p=clsql.git diff --git a/doc/ref-syntax.xml b/doc/ref-syntax.xml index e0e091e..787b4a3 100644 --- a/doc/ref-syntax.xml +++ b/doc/ref-syntax.xml @@ -23,7 +23,7 @@ ENABLE-SQL-READER-SYNTAX - Macro ENABLE-SQL-READER-SYNTAX + ENABLE-SQL-READER-SYNTAX Globally enable square bracket reader syntax. Macro @@ -84,6 +84,11 @@ The symbolic SQL syntax is disabled by default. + + &clsql; differs from &commonsql; in that + enable-sql-reader-syntax is defined as a + macro rather than a function. + @@ -92,7 +97,7 @@ DISABLE-SQL-READER-SYNTAX - Macro DISABLE-SQL-READER-SYNTAX + DISABLE-SQL-READER-SYNTAX Globally disable square bracket reader syntax. Macro @@ -153,6 +158,11 @@ The symbolic SQL syntax is disabled by default. + + &clsql; differs from &commonsql; in that + disable-sql-reader-syntax is defined as a + macro rather than a function. + @@ -161,7 +171,7 @@ LOCALLY-ENABLE-SQL-READER-SYNTAX - Macro LOCALLY-ENABLE-SQL-READER-SYNTAX + LOCALLY-ENABLE-SQL-READER-SYNTAX Globally enable square bracket reader syntax. Macro @@ -225,6 +235,11 @@ The symbolic SQL syntax is disabled by default. + + &clsql; differs from &commonsql; in that + locally-enable-sql-reader-syntax is + defined as a macro rather than a function. + @@ -234,7 +249,7 @@ LOCALLY-DISABLE-SQL-READER-SYNTAX - Macro LOCALLY-DISABLE-SQL-READER-SYNTAX + LOCALLY-DISABLE-SQL-READER-SYNTAX Locally disable square bracket reader syntax. Macro @@ -302,6 +317,11 @@ The symbolic SQL syntax is disabled by default. + + &clsql; differs from &commonsql; in that + locally-disable-sql-reader-syntax is + defined as a macro rather than a function. + @@ -310,7 +330,7 @@ RESTORE-SQL-READER-SYNTAX-STATE - Macro RESTORE-SQL-READER-SYNTAX-STATE + RESTORE-SQL-READER-SYNTAX-STATE Restore square bracket reader syntax to its previous state. @@ -381,6 +401,11 @@ The symbolic SQL syntax is disabled by default. + + &clsql; differs from &commonsql; in that + restore-sql-reader-syntax-state is + defined as a macro rather than a function. + @@ -389,7 +414,7 @@ SQL - Function SQL + SQL Construct an SQL string from supplied expressions. Function @@ -488,7 +513,7 @@ SQL-EXPRESSION - Function SQL-EXPRESSION + SQL-EXPRESSION Constructs an SQL expression from supplied keyword arguments. Function @@ -646,7 +671,7 @@ SQL-OPERATION - Function SQL-OPERATION + SQL-OPERATION Constructs an SQL expression from a supplied operator and arguments. Function @@ -750,7 +775,7 @@ SQL-OPERATOR - Function SQL-OPERATOR + SQL-OPERATOR Returns the symbol for the supplied SQL operator. Function @@ -816,117 +841,120 @@ Notes - &clsql;'s symbolic SQL syntax currently has support for - the following SQL operators: + + &clsql;'s symbolic SQL syntax currently has support for the + following &commonsql; compatible SQL operators: - any - , - some - , - all - , - not - , - union - , - intersect - , - minus - , + any + some + all + not + union + intersect + minus except - , + order-by - , + null - , + * - , + + - , + / - , + - - , + like - , + and - , + or - , + in - , + substr - , + || - , + = - , + < - , + > - , + >= - , + <= - , + <> - , + count - , + max - , + min - , + avg - , + sum - , + function - , + between - , + distinct - , + nvl - , + slot-value - , + userenv + + + + as well as the pseudo-operator function. + + The following operators are provided as &clsql; extensions to + the &commonsql; API. + - , concat - , + substring - , + limit - , + group-by - , + having - , + not-null - , + exists - , + uplike - , + is - , + == - , + the - , + coalesce - , + view-class - - as well as the pseudo-operator - function. Note that some of these operators - are not supported by all of the RDBMS supported by - &clsql;. + + + + Note that some of these operators are not supported by all of + the RDBMS supported by &clsql; (see the Appendix for details). +