Version 6.3 (Released March 1998)

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