This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:sql:functions:home [2010/07/27 04:44] els created |
dev:sql:functions:home [2011/03/31 14:49] 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) | ||
| + | |< 95% 100% >| | ||
| ^ Omnidex SQL Functions ^^^ | ^ Omnidex SQL Functions ^^^ | ||
| |**String Functions** ||| | |**String Functions** ||| | ||
| Line 36: | Line 37: | ||
| |[[dev:sql:functions:case|CASE]] ||| | |[[dev:sql:functions:case|CASE]] ||| | ||
| |[[dev:sql:functions:coalesce|COALESCE]] ||| | |[[dev:sql:functions:coalesce|COALESCE]] ||| | ||
| - | |[[dev:sql:functions:ifnull|IFNULL]] ||| | ||
| |[[dev:sql:functions:nullif|NULLIF]] ||| | |[[dev:sql:functions:nullif|NULLIF]] ||| | ||
| + | |[[dev:sql:functions:ifnull|$IFNULL]] ||| | ||
| | ||| | | ||| | ||
| |**Utility and Conversion Functions** ||| | |**Utility and Conversion 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 ====== | ||
| + | |< 95% 20% 24% 56% >| | ||
| ^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}} | ||