Name

Function SQL-OPERATOR — Returns the symbol for the supplied SQL operator.

Function

Syntax

      sql-operator operator => result

Arguments and Values

operator

A symbol denoting an SQL operator.

result

The Lisp symbol used by CLSQL to represent the specified operator.

Description

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.

Examples

(sql-operator 'like)
=> SQL-LIKE
      

Side Effects

None.

Affected by

None.

Exceptional Situations

None.

Notes

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.