DuroDBMS API
1.7
|
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, ..., dst_attr 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.