From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PCLabs Survey, Part VI: Query Language and Database Design |
Date: | 2000-01-31 21:38:56 |
Message-ID: | Pine.BSF.4.21.0001311738130.480-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 column in 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-01-31 21:39:33 | PCLabs Survey, Part VII: Embedded Database / Branch Office Support |
Previous Message | The Hermit Hacker | 2000-01-31 21:37:28 | PCLabs Survey, Part V: Programmability |