GSL_UINT_MAX= 2 ^ 64 - 1 = 18446744073709551615
GSQL_INT_MAX= 2 ^ 63 - 1 = 9223372036854775807
GSQL_INT_MIN= -2 ^ 63 = -9223372036854775808
LIKEoperator is used for string pattern matching and can only be used in
WHEREclauses. The expression
string1 LIKE string_patternevaluates to boolean true if
string1matches the pattern in
string_pattern; otherwise, it is false.
string1can be a function call (e.g.
string_patternmust be a string literal or a parameter. A
string_patterncan contain characters as well as the following wildcard and other special symbols, in order to express a pattern (
<char_list>indicates a placeholder):
%abc%matches any string which contains the sequence
_abc_ematches any 6-character string where the 2nd to 4th characters are
"abc"and the last character is
[^qxz]matches any character other than
[a-mA-M0-3]matches a letter from a to m, upper or lower case, or a digit from 0 to 3.
]No special treatment is needed for [ inside a char list.
%[\\]!]matches any string which ends with either
ESCAPE escape_charclause is used to define an escape character. When
string_pattern, then the next character is interpreted literally, instead of as a pattern matching operator. For example, if we want to specify the pattern "any string ending with the
'%'character", we could use
"%\%" ESCAPE "\"
"%"has its usual pattern-matching meaning "zero or more characters".
"\%"means a literal percentage character, because it starts with the escape character
RETURNSheader following its
CREATEstatement is called a subquery. A subquery acts as a callable function in GSQL. They take parameters, perform a set of actions, and return a value at the end. A subquery must end with a return statement to pass its output value to a query. Exactly one type is allowed in the
RETURNSheader, and thus the
RETURNstatement can only return one expression.
INSTALL QUERYcommand with the query that calls the subquery.
ListAccumwith a tuple as its element, the tuple does not need to be defined at the catalog level and can be anonymous.
person1, search to a distance of 1 and a distance of 2.