In "E.1.2. Migration to version 8.0" the folowing paragraph appears to use "one less than the current year" when it should be "one less than the correct year" based on later comments about that fix.
The extract() function (also called date_part) now returns the proper year for BC dates. It previously returned one less than the current year. The function now also returns the proper values for millennium and century. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match