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 |