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 [2009/12/04 22:40] tdo |
dev:sql:functions:home [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| ===== Standard SQL Functions ===== | ===== Standard SQL Functions ===== | ||
| + | |||
| + | The Omnidex SQL Language supports several standard SQL Functions. These functions operate as defined in the SQL specification. | ||
| ^ SQL Functions ^ Description ^ | ^ SQL Functions ^ Description ^ | ||
| Line 9: | Line 11: | ||
| | [[ CAST ]] | Convert an expression to a specific data type. | | | [[ CAST ]] | Convert an expression to a specific data type. | | ||
| | [[ dev:sql:functions:character_length:home | CHAR[ACTER]_LENGTH ]] | Return the number of characters in a string. | | | [[ dev:sql:functions:character_length:home | CHAR[ACTER]_LENGTH ]] | Return the number of characters in a string. | | ||
| - | | [[ dev:sql:functions:concatenation | || (Concatenation) ]] | Concatenate multiple characters strings into a single character string. | | + | | [[ dev:sql:functions:concatenation | || (Concatenation) ]] | Concatenate multiple columns or strings into a single character string. | |
| | [[ CURRENT_DATE]] | Return the current data from the system clock. | | | [[ CURRENT_DATE]] | Return the current data from the system clock. | | ||
| | [[ CURRENT_TIME]] | Return the current time from the system clock. | | | [[ CURRENT_TIME]] | Return the current time from the system clock. | | ||
| Line 19: | Line 21: | ||
| | [[ SUBSTRING]] | Return a specific part of a string. | | | [[ SUBSTRING]] | Return a specific part of a string. | | ||
| | [[ SESSION_USER]] | Return the current Omnidex user. | | | [[ SESSION_USER]] | Return the current Omnidex user. | | ||
| - | | [[ SYNONYMS]] | Use synonyms of a word or phrase as qualification criteria. | | ||
| | [[ SYSTEM_USER]] | Return the current system user. | | | [[ SYSTEM_USER]] | Return the current system user. | | ||
| | [[ TRIM ]] | Remove leading and/or trailing "pad" characters from a string. | | | [[ TRIM ]] | Remove leading and/or trailing "pad" characters from a string. | | ||
| Line 27: | Line 28: | ||
| ===== Omnidex Extended Functions ===== | ===== Omnidex Extended Functions ===== | ||
| - | The Omnidex SQL Language supports several functions that are extensions to the standard SQL Functions. Extended functions are prefixed with a $ so that they are easy to locate in existing SQL code. | + | The Omnidex SQL Language supports several functions that are extensions to the standard SQL Functions. Extended functions are prefixed with a ( %%$%% ) so that they are easy to locate in existing SQL code. |
| ^ Omnidex Functions ^ Description ^ | ^ Omnidex Functions ^ Description ^ | ||
| | [[ $CALC_DATE ]] | | | | [[ $CALC_DATE ]] | | | ||
| - | | [[ $COL_LEN]] | Return the length of a column as defined in the environment catalog. | | + | | [[ dev:sql:functions:col_length | $COL[UMN]_LENGTH ]] | Return the length of a column as defined in the environment catalog. Same as $COL_LEN. | |
| - | | [[ $COLUMN_LENGTH ]] | Return the length of a column as defined in the environment catalog. Same as $COL_LEN. | | + | |
| | [[ dev:sql:functions:contains:home | $CONTAINS ]] | | | | [[ dev:sql:functions:contains:home | $CONTAINS ]] | | | ||
| | [[ dev:sql:functions:context:home | $CONTEXT ]] | Return snippets of text from data qualified in a $CONTAINS function. | | | [[ dev:sql:functions:context:home | $CONTEXT ]] | Return snippets of text from data qualified in a $CONTAINS function. | | ||
| Line 39: | Line 39: | ||
| | [[ $CURRENT_ROW ]] | Return the current row number. | | | [[ $CURRENT_ROW ]] | Return the current row number. | | ||
| | [[ $DISTANCE ]] | | | | [[ $DISTANCE ]] | | | ||
| - | | [[ $DOUBLE_METAPHONE ]] | | | ||
| | [[ $EXTERNAL ]] | Execute an external user-defined function. | | | [[ $EXTERNAL ]] | Execute an external user-defined function. | | ||
| | [[ [[ dev:sql:functions:highlight_criteria:home | $HIGHLIGHT_CRITERIA ]] | | | | [[ [[ dev:sql:functions:highlight_criteria:home | $HIGHLIGHT_CRITERIA ]] | | | ||
| Line 47: | Line 46: | ||
| | [[ [[ dev:sql:functions:lookup:home | $LOOKUP ]] | Retrieve textual metadata. | | | [[ [[ dev:sql:functions:lookup:home | $LOOKUP ]] | Retrieve textual metadata. | | ||
| | [[ $LPAD ]] | Add leading "PAD" characters to a string. | | | [[ $LPAD ]] | Add leading "PAD" characters to a string. | | ||
| - | | [[ $METAPHONE ]] | | | ||
| | [[ $MOD ]] | Return "n modulus y" (remainder). | | | [[ $MOD ]] | Return "n modulus y" (remainder). | | ||
| | [[ $PROPER ]] | Shift the first letter of each word in a string to upper case and all other letters to lower case. | | | [[ $PROPER ]] | Shift the first letter of each word in a string to upper case and all other letters to lower case. | | ||