LucidDbCreateSqlUdf
From Eigenpedia
[edit]
Syntax
CREATE FUNCTION qualified-function-name ( [ function-param-def, ... ] )
RETURNS data-type
[ LANGUAGE SQL ]
[ PARAMETER STYLE SQL ]
[ SPECIFIC specific-name ]
[ [ NOT ] DETERMINISTIC ]
[ [ NOT ] DYNAMIC_FUNCTION ]
[ CONTAINS SQL | READS SQL DATA | MODIFIES SQL DATA ]
[ { RETURNS NULL | CALLED } ON NULL INPUT ]
[ SQL SECURITY { INVOKER | DEFINER } ]
RETURN value-expression
function-param-def ::= param-name data-type
See LucidDbValueExpression for specification of value-expression.
See LucidDbDataTypes for specification of data-type.
[edit]
Example
CREATE FUNCTION celsius_to_fahrenheit(c DOUBLE) RETURNS DOUBLE CONTAINS SQL RETURN c*1.8 + 32;
[edit]
