X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-syntax.xml;h=787b4a3b08b28d1c09672447ad171a28e7286984;hb=f18511cc6c02102720b137982dea2d32afbd411a;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
- MacroENABLE-SQL-READER-SYNTAX
+ ENABLE-SQL-READER-SYNTAXGlobally 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
- MacroDISABLE-SQL-READER-SYNTAX
+ DISABLE-SQL-READER-SYNTAXGlobally 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
- MacroLOCALLY-ENABLE-SQL-READER-SYNTAX
+ LOCALLY-ENABLE-SQL-READER-SYNTAXGlobally 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
- MacroLOCALLY-DISABLE-SQL-READER-SYNTAX
+ LOCALLY-DISABLE-SQL-READER-SYNTAXLocally 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
- MacroRESTORE-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
- FunctionSQL
+ SQLConstruct an SQL string from supplied expressions.Function
@@ -488,7 +513,7 @@
SQL-EXPRESSION
- FunctionSQL-EXPRESSION
+ SQL-EXPRESSIONConstructs an SQL expression from supplied keyword arguments.Function
@@ -646,7 +671,7 @@
SQL-OPERATION
- FunctionSQL-OPERATION
+ SQL-OPERATIONConstructs an SQL expression from a supplied operator and arguments.Function
@@ -750,7 +775,7 @@
SQL-OPERATOR
- FunctionSQL-OPERATOR
+ SQL-OPERATORReturns 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
+ minusexcept
- ,
+
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).
+