expression

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('query.expression_id_seq'::regclass)
case_branch.condition case_branch_condition_fkey R
case_branch.parent_expr case_branch_parent_expr_fkey C
case_branch.result case_branch_result_fkey R
expression.left_operand expression_left_operand_fkey R
expression.parent_expr expression_parent_expr_fkey C
expression.right_operand expression_right_operand_fkey R
from_relation.function_call from_relation_function_call_fkey R
from_relation.on_clause from_relation_on_clause_fkey R
order_by_item.expression order_by_item_expression_fkey C
select_item.expression select_item_expression_fkey R
stored_query.having_clause stored_query_having_clause_fkey R
stored_query.limit_count stored_query_limit_count_fkey R
stored_query.offset_count stored_query_offset_count_fkey R
stored_query.where_clause stored_query_where_clause_fkey R
type text 2147483647 null
parenthesize bool 1 false
parent_expr int4 10 √ null
expression.id expression_parent_expr_fkey C
seq_no int4 10 1
literal text 2147483647 √ null
table_alias text 2147483647 √ null
column_name text 2147483647 √ null
bind_variable.name Implied Constraint R
left_operand int4 10 √ null
expression.id expression_left_operand_fkey R
operator text 2147483647 √ null
right_operand int4 10 √ null
expression.id expression_right_operand_fkey R
function_id int4 10 √ null
function_sig.id expression_function_id_fkey R
subquery int4 10 √ null
stored_query.id expression_subquery_fkey R
cast_type int4 10 √ null
datatype.id expression_cast_type_fkey R
negate bool 1 false
bind_variable text 2147483647 √ null
bind_variable.name expression_bind_variable_fkey R

Indexes

Constraint Name Type Sort Column(s)
expression_pkey Primary key Asc id
query_expr_parent_seq Must be unique Asc/Asc parent_expr + seq_no

Check Constraints

Constraint Name Constraint
expression_type ((type = ANY (ARRAY['xbet'::text, 'xbind'::text, 'xbool'::text, 'xcase'::text, 'xcast'::text, 'xcol'::text, 'xex'::text, 'xfunc'::text, 'xin'::text, 'xisnull'::text, 'xnull'::text, 'xnum'::text, 'xop'::text, 'xser'::text, 'xstr'::text, 'xsubq'::text])))

Relationships

Close relationships within degrees of separation