I l @ ve RuBoard |
Subselects with EXISTS , IN , ALL , and ANY keywords (Vadim, Bruce, and Thomas). Added SQL-92 "constants" CURRENT_DATE , CURRENT_TIME , CURRENT_TIMESTAMP , and CURRENT_USER . Modified constraint syntax to be SQL-92 “compliant. Implemented SQL-92 PRIMARY KEY and UNIQUE clauses using indices. Recognized SQL-92 syntax for FOREIGN KEY . Allowed NOT NULL UNIQUE constraint clause (each allowed separately before). Allowed Postgres-style casting ( :: ) of nonconstants. Added support for SQL3 TRUE and FALSE Boolean constants. Support SQL-92 syntax for IS TRUE/IS FALSE/IS NOT TRUE/IS NOT FALSE . Allowed shorter strings for Boolean literals (for example, t , tr , tru ). Allowed SQL-92 delimited identifiers. Implemented SQL-92 binary and hexadecimal string decoding (b'10' and x'1F'). Supported SQL-92 syntax for type coercion of literal strings (for example, "DATETIME 'now'" ). Added conversions for int2 , int4 , and OID types to and from text. New SQL statement CREATE PROCEDURAL LANGUAGE . New Postgres Procedural Language (PL) back-end interface. Used indices for LIKE and ~, !~ operations. Added hash functions for datetime and timespan . Added UNIX domain socket support to back-end and front-end library. Implemented CREATE DATABASE/WITH LOCATION and initlocation utility. SET/SHOW/RESET TIME ZONE used TZ back-end environment variable. Implemented SET keyword = DEFAULT and SET TIME ZONE DEFAULT . Increased 16-character limit on system table/index names to 32 characters . Renamed system indices. Added 'GERMAN' option to SET DATESTYLE . Defined an ISO-style time-span output format with hh:mm:ss fields. Implemented day of year as possible input to date_part() . Defined timespan_finite() and text_timespan() functions. Allowed for a pg_password authentication database that was separate from the system password file. Dumped ACLs , GRANT , and REVOKE permissions. Defined text , varchar , and bpchar string-length functions. Fixed query handling for inheritance and cost computations . Implemented CREATE TABLE/AS SELECT (alternative to SELECT/INTO ). Allowed NOT , IS NULL , and IS NOT NULL in constraints. Implemented UNIONs for SELECT . Added UNION , GROUP , and DISTINCT to INSERT . Large patch for JDBC. New LOCK command and lock manual page describing deadlocks. Added new psql \da , \dd , \df , \do , \dS , and \dT commands. Showed NOT NULL and DEFAULT in psql \d table. New types for IP and MAC addresses in contrib /ip_and_mac . New python interface (PyGreSQL 2.0). New front-end/back-end protocol has a version number and network byte order. Security features in pg_hba.conf enhanced and documented; many cleanups. ecpg -embedded SQL preprocessor. |
I l @ ve RuBoard |