query.function_sig

↑ query schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: function_sig_return_type_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('query.function_sig_id_seq'::regclass)

function_name

text

No

return_type FK

integer

Yes

→ query.datatype(id)

is_aggregate

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

return_type

query.datatype(id)

NO ACTION

NO ACTION

DEFERRED

function_sig_return_type_fkey

Check Constraints

  • qfd_rtn_or_aggr: CHECK

Indexes

Index Method Definition

function_sig_pkey PK

btree

CREATE UNIQUE INDEX function_sig_pkey ON query.function_sig USING btree (id)

query_function_sig_name_idx

btree

CREATE INDEX query_function_sig_name_idx ON query.function_sig USING btree (function_name)

Referenced By

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

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

query.expression

function_id

id

expression_function_id_fkey

query.function_param_def

function_id

id

function_param_def_function_id_fkey
Previous
Next