|
DuroDBMS API
1.2
|
OPERATOR RELATION(t TUPLE { * }, ...) RETURNS RELATION { * };
The relation selector.
OPERATOR is_empty(RELATION { * }) RETURNS boolean;
Checks if a table is empty.
TRUE if the relation-valued operand is empty, RDB_FALSE otherwise.
OPERATOR count(RELATION { * }) RETURNS integer;
Counts the tuples in a table.
The cardinality of the relation-valued operand.
OPERATOR in (t TUPLE { * }, r RELATION { * }) RETURNS boolean;
Checks if a table contains a given tuple.
TRUE if r contains t, RDB_FALSE otherwise.
OPERATOR subset_of(r1 RELATION { * }, r2 RELATION { * }) RETURNS boolean;
Checks if a table is a subset of another table.
TRUE if the r1 is a subset of r2, RDB_FALSE otherwise.
OPERATOR any(r RELATION { * }, attr boolean) RETURNS boolean;
The any aggregate operator. For the semantics, see RDB_any().
OPERATOR all(r RELATION { * }, attr boolean) RETURNS boolean;
The all aggregate operator. For the semantics, see RDB_all().
OPERATOR avg(r RELATION { * }, attr integer) RETURNS float;
OPERATOR avg(r RELATION { * }, attr float) RETURNS float;
The avg aggregate operator. For the semantics, see RDB_avg().
OPERATOR max(r RELATION { * }, attr integer) RETURNS integer;
OPERATOR max(r RELATION { * }, attr float) RETURNS float;
The max aggregate operator. For the semantics, see RDB_max().
OPERATOR min(r RELATION { * }, attr integer) RETURNS integer;
OPERATOR min(r RELATION { * }, attr float) RETURNS float;
The min aggregate operator. For the semantics, see RDB_min().
OPERATOR SUM(r RELATION { * }, attr integer) RETURNS integer;
OPERATOR SUM(r RELATION { * }, attr float) RETURNS float;
The SUM aggregate operator. For the semantics, see RDB_sum().
OPERATOR divide(r1 RELATION { * }, r2 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
The relational three-argument (small) DIVIDE operator.
OPERATOR extend(r RELATION { * }, attrexp ANY, attrname string, ...) RETURNS RELATION { * };
OPERATOR group(r RELATION { * }, attrname string ...) RETURNS RELATION { * };
OPERATOR intersect(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR join(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR minus(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR project(r1 RELATION { * }, attrname string ...) RETURNS RELATION { * };
OPERATOR remove(r RELATION { * }, attrname string ...) RETURNS RELATION { * };
OPERATOR rename(r RELATION { * }, scr_attrname string, dst_attrname string ...) RETURNS RELATION { * };
OPERATOR ungroup(r RELATION { * }, attrname string) RETURNS RELATION { * };
OPERATOR union(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR d_union(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR update(r1 RELATION { * }, dst_attrname string, src_expr ANY, ...) RETURNS RELATION { * };
OPERATOR unwrap(attrname string, ...) RETURNS RELATION { * };
OPERATOR semijoin(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR semiminus(r1 RELATION { * }, r2 RELATION { * }) RETURNS RELATION { * };
OPERATOR summarize(r1 RELATION { * }, r2 RELATION { * }, expr ANY, attrname string, ...) RETURNS RELATION { * };
OPERATOR tclose(r RELATION { * }) RETURNS RELATION { * };
The transitive closure operator.
OPERATOR where(r RELATION { * }, b boolean) RETURNS RELATION { * };
The relational WHERE operator.
OPERATOR wrap(r RELATION { * }, src_attrs ARRAY OF string, dst_attr string ...) RETURNS RELATION { * };
The relational WRAP operator.
OPERATOR = (ANY, ANY) RETURNS boolean;
The equality operator. Defined for every type. The arguments must be of the same type.
TRUE if the two arguments are equal, FALSE otherwise.
OPERATOR <> (ANY, ANY) RETURNS boolean;
The inequality operator. Defined for every type. The arguments must be of the same type.
TRUE if the two arguments are not equal, FALSE otherwise.
OPERATOR < (integer, integer) RETURNS boolean;
OPERATOR < (float, float) RETURNS boolean;
OPERATOR < (string, string) RETURNS boolean;
The lower-than operator.
TRUE if the first argument is lower than the first. If the operands are strings, the strings will be compared using strcoll().
OPERATOR <= (integer, integer) RETURNS boolean;
OPERATOR <= (float, float) RETURNS boolean;
OPERATOR <= (string, string) RETURNS boolean;
The lower-than-or-equal operator.
TRUE if the first argument is lower than or equal to the second. If the operands are strings, the strings will be compared using strcoll().
OPERATOR > (integer, integer) RETURNS boolean;
OPERATOR > (float, float) RETURNS boolean;
OPERATOR > (string, string) RETURNS boolean;
The greater-than operator.
TRUE if the first argument is greater than the first. If the operands are strings, the strings will be compared using strcoll().
OPERATOR >= (integer, integer) RETURNS boolean;
OPERATOR >= (float, float) RETURNS boolean;
OPERATOR >= (string, string) RETURNS boolean;
The greater-than-or-equal operator.
TRUE if the first argument is greater than or equal to the second. If the operands are strings, the strings will be compared using strcoll().
OPERATOR and (boolean, boolean) RETURNS boolean;
The boolean AND operator.
OPERATOR or (boolean, boolean) RETURNS boolean;
The boolean OR operator.
OPERATOR xor (boolean, boolean) RETURNS boolean;
The boolean XOR operator.
OPERATOR not (boolean) RETURNS boolean;
The boolean NOT operator.
OPERATOR IF (B boolean, V1 ANY, V2 ANY) RETURNS ANY;
The IF-THEN-ELSE operator.
V1 if B is TRUE, V2 otherwise.
OPERATOR || (s1 string, s2 string) RETURNS string;
The string concatenation operator.
The result of the concatenation of the operands.
OPERATOR strlen (s string) RETURNS integer;
The string length operator.
The length of s, in code points.
OPERATOR strlen_b (s string) RETURNS integer;
The string length operator, returning the number of bytes.
The length of s, in bytes.
OPERATOR substr(s string, start integer, length integer) RETURNS string;
Extracts a substring.
The substring of s with length length starting at position start. length and start are measured in code points, according to the current encoding.
OPERATOR substr_b(s string, start integer, length integer) RETURNS string;
OPERATOR substr_b(s string, start integer) RETURNS string;
Extracts a substring.
The substring of s with length length starting at position start. length and start are measured in bytes. If called with 2 arguments, the substring extends to the end of s.
OPERATOR strfind_b (haystack string, needle string) RETURNS integer;
OPERATOR strfind_b (haystack string, needle string, int pos) RETURNS integer;
Finds the first occurrence of the string needle in the string haystack. If called with 3 arguments, it finds the first occurrence after pos, where pos is a byte offset.
The position of the substring, in bytes, or -1 if the substring has not been found.
OPERATOR starts_with (s string, prefix string) RETURNS boolean;
Tests if string s starts with string prefix.
TRUE if s starts with prefix, FALSE otherwise
OPERATOR like (s string, pattern string) RETURNS boolean;
Pattern matching operator. A period ('.') matches a single character; an asterisk ('*') matches zero or more characters.
TRUE if s matches pattern, RDB_FALSE otherwise.
OPERATOR regex_like (s string, pattern string) RETURNS boolean;
The regular expression matching operator.
TRUE if s matches pattern, RDB_FALSE otherwise.
OPERATOR format (format string, ...) RETURNS string;
Generates a formatted string in the style of sprintf. The arguments passed after format must be of type string, integer, or float and must match the format argument.
The formatted string.
OPERATOR cast_as_integer (float) RETURNS integer;
OPERATOR cast_as_integer (string) RETURNS integer;
Converts the operand to integer.
The operand, converted to integer.
OPERATOR cast_as_float (integer) RETURNS float;
OPERATOR cast_as_float (string) RETURNS float;
Converts the operand to float.
The operand, converted to float.
OPERATOR cast_as_string (integer) RETURNS string;
OPERATOR cast_as_string (float) RETURNS string;
OPERATOR cast_as_string (binary) RETURNS string;
Converts the operand to a string.
The operand, converted to string.
OPERATOR cast_as_string (string) RETURNS binary;
Converts the operand to a binary, without a terminating nullbyte.
The operand, converted to string.
OPERATOR serialize (value ANY) RETURNS binary;
Converts a value to a binary representation which includes the type.
The operand, converted to binary representation.
OPERATOR + (integer, integer) RETURNS integer;
OPERATOR + (float, float) RETURNS float;
The addition operator.
The sum of the two operands.
OPERATOR - (integer) RETURNS integer;
OPERATOR - (float) RETURNS float;
The unary minus operator.
The operand, sign inverted.
OPERATOR - (integer, integer) RETURNS integer;
OPERATOR - (float, float) RETURNS float;
The subtraction operator.
The difference of the two operands.
OPERATOR * (integer, integer) RETURNS integer;;
OPERATOR * (float, float) RETURNS float;
The multiplication operator.
The product of the two operands.
OPERATOR / (integer, integer) RETURNS integer;
OPERATOR / (float, float) RETURNS float;
The division operator.
The quotient of the operators.
OPERATOR sqrt(x float) RETURNS float;
The square root operator.
OPERATOR abs(x integer) RETURNS integer;
OPERATOR abs(x float) RETURNS float;
The abs(absolute value) operator.
OPERATOR sin (x float) RETURNS float;
The sine operator.
OPERATOR cos(x float) RETURNS float;
The cosine operator.
OPERATOR atan(x float) RETURNS float;
The arc tangent operator.
OPERATOR atan2(y float, x float) RETURNS float;
The atan2 operator.
OPERATOR power(b float, x float) RETURNS float;
The power operator.
OPERATOR exp(x float) RETURNS float;
The exponential function operator.
OPERATOR ln(x float) RETURNS float;
The natural logarithm operator.
OPERATOR log(x float) RETURNS float;
The base 10 logarithm operator.
OPERATOR TUPLE(ATTRNAME string, ATTRVAL ANY, ...) RETURNS TUPLE { * };
The tuple selector.
OPERATOR to_tuple(r RELATION { * }) RETURNS TUPLE { * };
Extracts a single tuple from a relation.
OPERATOR array(ANY, ...) RETURNS ARRAY;
The array selector.
OPERATOR length (ARRAY) RETURNS integer;
The array length operator.
The length of the operand.
OPERATOR index_of (arr ARRAY, data ANY) RETURNS integer;
Returns the index of the first occurrence of data in the array ARR.
The index, or -1 if data does not appear in the array.
1.8.6