SQL-OPERATOR — Returns the symbol for the supplied SQL operator.
Function
A symbol denoting an SQL operator.
The Lisp symbol used by CLSQL to represent the specified operator.
Returns the Lisp symbol corresponding to the SQL operator represented by the symbol operator. If operator does not represent a supported SQL operator or is not a symbol, nil is returned.
CLSQL's symbolic SQL syntax currently has support for the following CommonSQL compatible SQL operators:
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 |
Note that some of these operators are not supported by all of the RDBMS supported by CLSQL (see the Appendix for details).