Function 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 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 |
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.