Version 6.2.1 (Released October 1997)

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) ...

Get PostgreSQL Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.