Version 6.2.1 (Released October 1997)

I l @ ve RuBoard

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) and rudimentary DECIMAL(p,s) , NUMERIC(p,s) (SQL-92).

Defined EXTRACT() , POSITION() , SUBSTRING() , and TRIM() (SQL-92).

Defined CURRENT_DATE , CURRENT_TIME , CURRENT_TIMESTAMP (SQL-92).

Added syntax and warnings for UNION , HAVING , INNER , and OUTERJOIN (SQL-92).

Allowed hh:mm:ss time entry for timespan/reltime types.

Added center() routines for lseg , path , and polygon .

Added distance() routines for circle-polygon and polygon-polygon .

Added routine to convert circle-box .

Replaced distance operator <===> with <-> .

Replaced above operator !^ with >^ and below operator ! with <^ .

Added routines for text trimming on both ends, substring, and string position.

Added conversion routines circle(box) and poly(circle) .

Allowed internal sorts to be stored in memory rather than in files.

General trigger functions for referential integrity.

MOVE implementation.

I l @ ve RuBoard


PostgreSQL Essential Reference
PostgreSQL Essential Reference
ISBN: 0735711216
EAN: 2147483647
Year: 2001
Pages: 118
Authors: Barry Stinson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net