October 2001
Beginner to intermediate
400 pages
7h 45m
English
Added JDBC driver as an interface.
Added pg_password utility.
Return number of tuples inserted/affected by INSERT/UPDATE/DELETE and so on.
Triggers implemented with CREATE TRIGGER (SQL3).
SPI (server programming interface) allowed execution of queries inside C functions.
NOT NULL implemented per SQL-92 standard.
Implement extended comments (/* … */) using exclusive states.
Added // single-line comments.
Implemented DEFAULT and CONSTRAINT for tables (SQL-92).
Added text concatenation operator and function (SQL-92).
Support WITH TIME ZONE syntax (SQL-92).
Support INTERVAL unit to unit syntax (SQL-92).
Defined types DOUBLE PRECISION, INTERVAL, CHARACTER, and CHARACTER VARYING (SQL-92).
Defined type FLOAT(p) ...
Read now
Unlock full access