X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-syntax.xml;h=dd0dd0ef4f6d732328695eca2472ad5d72fdf060;hb=a6131d02d6b3c41ccb0ae411f8132857b39aa2f4;hp=da28038a03db73c881a5d06b153c1bf6913d3140;hpb=5edc92aee527621ed13245b5b7892e40c2cd443f;p=clsql.git diff --git a/doc/ref-syntax.xml b/doc/ref-syntax.xml index da28038..dd0dd0e 100644 --- a/doc/ref-syntax.xml +++ b/doc/ref-syntax.xml @@ -409,6 +409,80 @@ + + + FILE-ENABLE-SQL-READER-SYNTAX + + + FILE-ENABLE-SQL-READER-SYNTAX + + Enable the square bracket reader syntax for the duration of the file. + + Macro + + + Syntax + + file-enable-sql-reader-syntax => + + + Arguments and Values + None. + + + Description + Uncoditionally enables the SQL reader syntax. Unlike + enable-sql-reader-syntax and + disable-sql-reader-syntax which try to keep track of whether + the syntax has been enabled or disabled and keep track of the old read-table for restoration this function just enables it unconditionally. + + Once enabled this way there is no corresponding disable function but instead relies on being used in a file context. The spec for load and compile-file states that the *readtable* will be restored after processing the file. + + + Examples + Intended to be used at the top of a file that contains sql reader syntax. + + (in-package :my-package) + (clsql:file-enable-sql-reader-syntax) + ... + ;;functions that use the square bracket syntax. + + + + Side Effects + + Modifies the readtable. + + + + Affected by + None. + + + Exceptional Situations + + None. + + + + See Also + + enable-sql-reader-syntax + disable-sql-reader-syntax + locally-enable-sql-reader-syntax + locally-disable-sql-reader-syntax + + + + Notes + + Unique to &clsql;, not present in &commonsql;. + + + + SQL @@ -847,80 +921,73 @@ - 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. @@ -930,30 +997,30 @@ concat - , + substring - , + limit - , + group-by - , + having - , + not-null - , + exists - , + uplike - , + is - , + == - , + the - , + coalesce - , - view-class. + + view-class