The equality operator. Defined for every type. The arguments must be of the same type.
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 + (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 AND (BOOLEAN, BOOLEAN) RETURNS BOOLEAN;
The boolean AND operator.
OPERATOR OR (BOOLEAN, BOOLEAN) RETURNS BOOLEAN;
The boolean OR operator.
OPERATOR NOT (BOOLEAN) RETURNS BOOLEAN;
The boolean NOT operator.
OPERATOR || (STRING, STRING) RETURNS STRING;
The string concatenation operator.
The result of the concatenation of the operands.
OPERATOR LENGTH (STRING) RETURNS INTEGER;
The string length operator.
The length of the operand.
OPERATOR SUBSTRING(S STRING, START INTEGER, LENGTH INTEGER) RETURNS STRING;
The substring operator.
The substring of S with length LENGTH starting at position START.
OPERATOR MATCHES (S STRING, PATTERN STRING) RETURNS BOOLEAN;
The regular expression matching operator.
RDB_TRUE if S matches PATTERN, RDB_FALSE otherwise.
OPERATOR INTEGER (FLOAT) RETURNS INTEGER;
OPERATOR INTEGER (STRING) RETURNS INTEGER;
Converts the operand to INTEGER.
The operand, converted to INTEGER.
OPERATOR FLOAT (INTEGER) RETURNS FLOAT;
OPERATOR FLOAT (STRING) RETURNS FLOAT;
Converts the operand to FLOAT.
The operand, converted to FLOAT.
OPERATOR STRING (INTEGER) RETURNS STRING;
OPERATOR STRING (FLOAT) RETURNS STRING;
Converts the operand to a string.
The operand, converted to STRING.
OPERATOR IS_EMPTY (RELATION) RETURNS BOOLEAN;
Checks if a table is empty.
RDB_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.
RDB_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.
RDB_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 IF (B BOOLEAN, V1 ANY, V2 ANY) RETURNS ANY;
The IF-THEN-ELSE operator.
V1 if B is RDB_TRUE, V2 otherwise.
OPERATOR TUPLE(ATTRNAME STRING, ATTRVAL STRING, ...) RETURNS TUPLE;
The tuple selector.
OPERATOR RELATION(T TUPLE, ...) RETURNS RELATION;
The relation selector.
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, SRC_ATTRNAME STRING, DST_ATTRNAME STRING ...) RETURNS RELATION;
OPERATOR UNGROUP(R RELATION, ATTRNAME STRING) RETURNS RELATION;
OPERATOR 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 WHERE(R RELATION, B BOOLEAN) RETURNS RELATION;
OPERATOR WRAP(R RELATION, SRC_ATTRS ARRAY OF STRING, DST_ATTR STRING ...) RETURNS RELATION;
1.5.1