LispWorks User Guide and Reference Manual > 19 Common SQL > 19.5 Symbolic SQL syntax > 19.5.1 The "[...]" Syntax

NextPrevUpTopContentsIndex

19.5.1.3 Calling database functions

An arbitrary function can be included in the SQL using the pseudo operator sql-function . The first argument is the function name and the rest are its arguments, for example:

(select [sql-function "COS" [age]] :from [EMPLOYEES])
(insert-records 
 :into [atable] 
 :attributes '(a b) 
 :values 
 (list 1 [sql-function "TO_DATE" "02/06/99" "mm/DD/RR"]))

Also you can call SQL infix operators using the pseudo operators sql-boolean-operator and sql-operator .


LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex