@@ -43,7 +43,7 @@ Migration to 7.2
4343
4444
4545
46- AS OF 2001-09-13
46+ AS OF 2001-10-25
4747
4848Bug Fixes
4949---------
@@ -141,6 +141,7 @@ DROP AGGREGATE and COMMENT ON AGGREGATE now accept an aggtype (Tom)
141141Prevent output of default index op class in pg_dump (Tom)
142142Allow trailing semicolons in psql backslash commands (Greg Sabino Mullane)
143143Prompt for psql password from /dev/tty if possible
144+ Allow SPI column functions to work for system columns (Tom)
144145
145146Types
146147-----
@@ -161,7 +162,7 @@ New TIMEZONE WITHOUT TIMEZONE data types (Thomas)
161162Add ISO date/time specification with 'T', yyyy-mm-ddThh:mm:ss (Thomas)
162163New xid/int comparison functions (Hiroshi)
163164Fix TID sequential scans (Hiroshi)
164- Add precision to TIMETIMESTAMP data types (Thomas)
165+ Add precision to TIME, TIMESTAMP, andINVERVAL data types (Thomas)
165166Cachability fixes (Thomas, Tom)
166167PL/TCL now reports errorInfo (Vsevolod Lobko)
167168Modify type coersion logic to attempt binary-compatible functions first (Tom)
@@ -170,8 +171,9 @@ Add compatibility functions to odbc.sql (Peter E)
170171Force new password prompt when changing user and database in psql (Tatsuo, Tom)
171172New /contrib/tsearch full text indexing (Oleg, Teodor Sigaev)
172173Allow better selectivity with Nan and infinities in NUMERIC (Tom)
173- Accept an INTERVAL argument for SET TIME ZONE (Thomas)
174- Implement INTERVAL() YEA
174+ Add INTERVAL argument for SET TIME ZONE (Thomas)
175+ Add INTERVAL() YEAR TO MONTH (etc) syntax (Thomas)
176+
175177Performance
176178-----------
177179Optimizer improvements (Tom)
218220Add isNullable() (Rene Pijlman)
219221JDBC date/time test suite fixes (Liam Stewart)
220222Fix for SELECT 'id' AS xxx FROM table (Dave Cramer)
223+ DatabaseMetaData patch to show precision properly (Mark Lillywhite)
221224ODBC
222225Remove query limit (Hiroshi)
223226Remove text field size limit (Hiroshi)