This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oaenv:home [2009/12/18 16:43] admin |
oaenv:home [2009/12/18 16:45] admin |
||
|---|---|---|---|
| Line 332: | Line 332: | ||
| == COLUMN column_name == | == COLUMN column_name == | ||
| - | [[[environment_name.]database_name.]table_name.]column_name[(start, length)] | + | [[[environment_name.]database_name.]table_name.]column_name[(start, length)] |
| column_name represents a non-ambiguous column or portion of a column. | column_name represents a non-ambiguous column or portion of a column. | ||
| Line 389: | Line 389: | ||
| DOUBLE Double-precision floating point data stored in 8 bytes. This is equivalent to a “datatype FLOAT length 8”. | DOUBLE Double-precision floating point data stored in 8 bytes. This is equivalent to a “datatype FLOAT length 8”. | ||
| + | |||
| <code> | <code> | ||
| Figure 2 - Examples of Declaring Datatypes Using New and Existing Syntax | Figure 2 - Examples of Declaring Datatypes Using New and Existing Syntax | ||
| Line 447: | Line 448: | ||
| OMNIDEX BLOB 1999 bytes bytes + 4 | OMNIDEX BLOB 1999 bytes bytes + 4 | ||
| </code> | </code> | ||
| + | |||
| ==== LENGTH n ==== | ==== LENGTH n ==== | ||
| Line 532: | Line 534: | ||
| The cardinality of a column is the number of distinct values in the column. This number should be near the actual column cardinality. Omnidex uses this number to better optimize some queries. | The cardinality of a column is the number of distinct values in the column. This number should be near the actual column cardinality. Omnidex uses this number to better optimize some queries. | ||
| + | |||
| ===== $RETRIEVE_FILE ===== | ===== $RETRIEVE_FILE ===== | ||
| + | |||
| <code> | <code> | ||
| $RETRIEVE_FILE(filename [,’datatype’ [,length [,’options’]]]) | $RETRIEVE_FILE(filename [,’datatype’ [,length [,’options’]]]) | ||