October 2001
Beginner to intermediate
400 pages
7h 45m
English
BTREE UNIQUE added to bulk load code.
Massive changes to libpg++ (Leo).
New GEQO optimizer speeds table multitable optimization.
New WARN message for nonunique insert into unique key.
New plaintext password functions.
New ANSI timestamp function.
New ANSI time and date types.
Multicolumn B-Tree indexes.
New SET var TO value command.
New locale settings for character types.
New SEQUENCE serial number generator.
GROUP BY function now possible.
New MONEY data type.
New VACUUM option for attribute statistics and for certain columns.
New SET, SHOW, and RESET commands.
New \connect database USER option.
New destroydb -i option.
New \dt and \di psql commands.
SELECT \n now escapes newline.
Read now
Unlock full access