syntax:types
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
syntax:types [2017/12/23 09:44] – dmitry | syntax:types [2019/11/02 07:45] – [Sort order] dmitry | ||
---|---|---|---|
Line 16: | Line 16: | ||
< | < | ||
- | To convert text values to numbers see [[syntax: | + | To convert text values to numbers see the [[syntax: |
==== Dates ==== | ==== Dates ==== | ||
Line 38: | Line 38: | ||
Note: Ampersand (&) is the text concatenation operator. | Note: Ampersand (&) is the text concatenation operator. | ||
- | To convert | + | To convert |
==== Boolean ==== | ==== Boolean ==== | ||
Line 45: | Line 45: | ||
==== Error ==== | ==== Error ==== | ||
- | Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using [[syntax: | + | Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using the [[syntax: |
+ | |||
+ | You can also create an error values use the [[syntax: | ||
==== Empty values ==== | ==== Empty values ==== | ||
- | If a table cell has no value - it's so called //empty value//. You can check if a column value is empty using [[syntax: | + | If a table cell has no value - it' |
Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. | Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. | ||
Line 57: | Line 59: | ||
==== Sort order ==== | ==== Sort order ==== | ||
- | Since in EasyMorph a column can contain values of different types, sorting is also applicable to mixed columns. In case of mixed types ascending sort order is as follows: | + | Since in EasyMorph a column can contain values of different types, sorting is also applicable to mixed columns. In case of mixed types the ascending sort order is as follows: |
* Empty cells and errors | * Empty cells and errors | ||
* Booleans | * Booleans | ||
Line 63: | Line 65: | ||
* Numbers | * Numbers | ||
- | Which means that empty cells and errors are less than anything else, booleans are less than text and numbers, text is less than numbers, numbers are greater than anything else. | + | Which means that empty cells and errors are less than anything else, booleans are less than text and numbers, text is less than numbers, numbers are greater than any other data type. |
syntax/types.txt · Last modified: 2021/05/12 07:33 by dmitry