Next Prev Up Top Contents Index

16.5.1.3 Calling database functions

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

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

LispWorks User Guide - 18 Feb 2003

Next Prev Up Top Contents Index