This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:functions:home [2010/07/27 20:54] els |
dev:sql:functions:home [2011/03/31 14:50] doc |
||
---|---|---|---|
Line 4: | Line 4: | ||
(This will be converted to a three-column once the underlying pages are written) | (This will be converted to a three-column once the underlying pages are written) | ||
+ | |< 100% 100% >| | ||
^ Omnidex SQL Functions ^^^ | ^ Omnidex SQL Functions ^^^ | ||
|**String Functions** ||| | |**String Functions** ||| | ||
Line 45: | Line 46: | ||
|[[dev:sql:functions:data_length|$DATA_LENGTH]] ||| | |[[dev:sql:functions:data_length|$DATA_LENGTH]] ||| | ||
|[[dev:sql:functions:distance|$DISTANCE]] ||| | |[[dev:sql:functions:distance|$DISTANCE]] ||| | ||
- | |[[dev:sql:functions:external|$EXTERNAL]] ||| | ||
| ||| | | ||| | ||
|**Variables** ||| | |**Variables** ||| | ||
Line 80: | Line 80: | ||
|[[dev:sql:functions:to_number|TO_NUMBER]] ||| | |[[dev:sql:functions:to_number|TO_NUMBER]] ||| | ||
| ||| | | ||| | ||
- | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | ||
====== Omnidex SQL Function Descriptions ====== | ====== Omnidex SQL Function Descriptions ====== | ||
+ | |< 100% 20% 20% 60% >| | ||
^Function ^Parameters ^Description ^ | ^Function ^Parameters ^Description ^ | ||
| ||| | | ||| | ||
Line 106: | Line 106: | ||
| [[dev:sql:functions:trunc | TRUNC ]] | (num_expr [, digits]) | Return a numeric expression truncated to a specified number of digits to the right of the decimal point. | | | [[dev:sql:functions:trunc | TRUNC ]] | (num_expr [, digits]) | Return a numeric expression truncated to a specified number of digits to the right of the decimal point. | | ||
| [[dev:sql:functions:random | $RANDOM ]] | (num_expr [, seed]) | Return a pseudo-random number. | | | [[dev:sql:functions:random | $RANDOM ]] | (num_expr [, seed]) | Return a pseudo-random number. | | ||
- | |--------------------------------------|-----------------------------------------------|----------------------------------------------------------------------------------------------------------| | ||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} |