Extended Syntax

Creating a table

INHERITS ( parent_table [, ... ] )

Currently, the syntax of inherited tables is retained but is not supported.

column_constraint:

REFERENCES reftable

[ ( refcolumn ) ] [ MATCH

FULL | MATCH PARTIAL |

MATCH SIMPLE ][ ON

DELETE action ] [ ON

UPDATE action ]

You can run REFERENCES reftable[(refcolumn)] [MATCH FULL |MATCH PARTIAL | MATCH SIMPLE] [ON DELETE action] [ON UPDATE action] to create foreign key constraints for tables.

Aggregate functions

CREATE AGGREGATE

Defines a new aggregate function.

ALTER AGGREGATE

Alters the definition of an aggregate function.

DROP AGGREGATE

Drops an existing aggregate function.