Differences

This shows you the differences between two versions of the page.

--- syntax:types [2017/12/23 09:48] – dmitry
+++ syntax:types [2021/05/12 07:33] (current) – [Empty values] dmitry
@@ Line 50: / Line 50: @@
 ==== Empty values ====
-If a table cell has no value - it's the so called //empty value//. You can check if a column value is empty using [[syntax:functions:isempty]] function. The length of an empty value is always zero.
+If a table cell has no value - it's the so-called //empty value//. You can check if a column value is empty using the [[syntax:functions:isempty]] function. The length of an empty value is always zero.
-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.
+An empty value is somewhat similar to NULL in relational databases but not exactly. For instance, an empty value always equals another empty value. Also, it equals an empty string (zero-length text value) when using the equality operator.
 All these comparisons are true:
@@ Line 59: / Line 59: @@
 ==== 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
   * Booleans
@@ Line 65: / Line 65: @@
   * 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.