query.expression

Cascading Deletes: Deleting rows from this table will cascade to: query.expression.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: expression_bind_variable_fkey, expression_cast_type_fkey, expression_function_id_fkey, expression_left_operand_fkey, expression_parent_expr_fkey, expression_right_operand_fkey, expression_subquery_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.expression_id_seq'::regclass)
type	`text`	No
parenthesize	`boolean`	No	false
parent_expr FK	`integer`	Yes		→ query.expression(id)
seq_no	`integer`	No	1
literal	`text`	Yes
table_alias	`text`	Yes
column_name	`text`	Yes
left_operand FK	`integer`	Yes		→ query.expression(id)
operator	`text`	Yes
right_operand FK	`integer`	Yes		→ query.expression(id)
function_id FK	`integer`	Yes		→ query.function_sig(id)
subquery FK	`integer`	Yes		→ query.stored_query(id)
cast_type FK	`integer`	Yes		→ query.datatype(id)
negate	`boolean`	No	false
bind_variable FK	`text`	Yes		→ query.bind_variable(name)

id PK

integer

nextval('query.expression_id_seq'::regclass)

type

text

parenthesize

boolean

false

parent_expr FK

integer

Yes

→ query.expression(id)

seq_no

integer

literal

text

Yes

table_alias

text

Yes

column_name

text

Yes

left_operand FK

integer

Yes

→ query.expression(id)

operator

text

Yes

right_operand FK

integer

Yes

→ query.expression(id)

function_id FK

integer

Yes

→ query.function_sig(id)

subquery FK

integer

Yes

→ query.stored_query(id)

cast_type FK

integer

Yes

→ query.datatype(id)

negate

boolean

false

bind_variable FK

text

Yes

→ query.bind_variable(name)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`bind_variable`	query.bind_variable(name)	NO ACTION	NO ACTION	DEFERRED	`expression_bind_variable_fkey`
`cast_type`	query.datatype(id)	NO ACTION	NO ACTION	DEFERRED	`expression_cast_type_fkey`
`function_id`	query.function_sig(id)	NO ACTION	NO ACTION	DEFERRED	`expression_function_id_fkey`
`left_operand`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`expression_left_operand_fkey`
`parent_expr`	query.expression(id)	CASCADE	NO ACTION	DEFERRED	`expression_parent_expr_fkey`
`right_operand`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`expression_right_operand_fkey`
`subquery`	query.stored_query(id)	NO ACTION	NO ACTION	DEFERRED	`expression_subquery_fkey`

bind_variable

query.bind_variable(name)

NO ACTION

DEFERRED

expression_bind_variable_fkey

cast_type

query.datatype(id)

NO ACTION

DEFERRED

expression_cast_type_fkey

function_id

query.function_sig(id)

NO ACTION

DEFERRED

expression_function_id_fkey

left_operand

query.expression(id)

NO ACTION

DEFERRED

expression_left_operand_fkey

parent_expr

query.expression(id)

CASCADE

NO ACTION

DEFERRED

expression_parent_expr_fkey

right_operand

query.expression(id)

NO ACTION

DEFERRED

expression_right_operand_fkey

subquery

query.stored_query(id)

NO ACTION

DEFERRED

expression_subquery_fkey

Check Constraints

expression_type: CHECK 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])

Indexes

Index Method Definition

Index	Method	Definition
`expression_pkey` PK	btree	`CREATE UNIQUE INDEX expression_pkey ON query.expression USING btree (id)`
`query_expr_parent_seq` UNIQUE	btree	`CREATE UNIQUE INDEX query_expr_parent_seq ON query.expression USING btree (parent_expr, seq_no) WHERE (parent_expr IS NOT NULL)`

expression_pkey PK

btree

CREATE UNIQUE INDEX expression_pkey ON query.expression USING btree (id)

query_expr_parent_seq UNIQUE

btree

CREATE UNIQUE INDEX query_expr_parent_seq ON query.expression USING btree (parent_expr, seq_no) WHERE (parent_expr IS NOT NULL)

Referenced By

The following tables have foreign keys pointing to query.expression (14 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
query.case_branch	`condition`	`id`	`case_branch_condition_fkey`
query.case_branch	`parent_expr`	`id`	`case_branch_parent_expr_fkey`
query.case_branch	`result`	`id`	`case_branch_result_fkey`
query.expression	`left_operand`	`id`	`expression_left_operand_fkey`
query.expression	`parent_expr`	`id`	`expression_parent_expr_fkey`
query.expression	`right_operand`	`id`	`expression_right_operand_fkey`
query.from_relation	`function_call`	`id`	`from_relation_function_call_fkey`
query.from_relation	`on_clause`	`id`	`from_relation_on_clause_fkey`
query.order_by_item	`expression`	`id`	`order_by_item_expression_fkey`
query.select_item	`expression`	`id`	`select_item_expression_fkey`
query.stored_query	`having_clause`	`id`	`stored_query_having_clause_fkey`
query.stored_query	`limit_count`	`id`	`stored_query_limit_count_fkey`
query.stored_query	`offset_count`	`id`	`stored_query_offset_count_fkey`
query.stored_query	`where_clause`	`id`	`stored_query_where_clause_fkey`