Parameter Types in User-Defined Functions

Prev Next

Overview

List of supported parameter types
X = Accepted type
C = This parameter type will be converted to targeted type (e.g. a string containing a number to a numeral)

Mnemonic Numeral Date String Boolean set Void Code
numeral X
numeral or set X C C C
date X
to date (see 1) C X C
numeral or date X X
numeral or date or blank X X X if blank
string X
to string (see 2) C C X C
numeral or blank X X if blank
numeral or blank to zero X 0 if blank
numeral or string X X
date or string X X
numerals C (see 3) X
numeral or string or date X X X
numeral or string or date string X X X
boolean X
columns X X X
numeral or boolean X X
scalars X X X X
parameters X
to parameters C (see 4) X
parameters members to string X (see 5)
to parameters members to string C (see 4) X (see 5)
string or parameters X X
valid X X X X X
all X X X X X X

Notes:
1. Conversion similar as implemented in the date() function.
2. Conversion similar as implemented in the str() function.
3. Even if only one numeral is provided, the user function gets a set containing one numeric element.
4. Conversion similar as implemented in the str() function.
5. The members in the set will be converted to string. Example: {1,2,true} -> {'1','2','true'}