Query Language and Database Design
- ANSI/ISO standards compliance - SQL standard supplied (e.g. SQL-89, SQL-92 entry level, any SQL3 support, etc.)
- SQL-92 catalog schema views - ANSI isolation levels supported
- left, right and full outer joins
- declarative referential integrity - declarative cascade delete - declarative cascade update
- ability to modify existing designs - rename table - modify data type of existing column - add/drop
columnin existing table - add/drop constraint in existing table
- more than one unique constraint per table
- object-oriented design support (abstract types, inheritance)
- object references (REFs)
- computed columns
- can build an index on a computed column
- computed tables
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org