CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl@hub.org 01/05/03 15:00:37
Modified files:
src/backend/access/nbtree: nbtcompare.c
src/backend/utils/adt: date.c float.c nabstime.c numeric.c
timestamp.c varbit.c varchar.c varlena.c
src/include/utils: nabstime.h
src/test/regress/expected: abstime-solaris-1947.out abstime.out
timestamp.out
Log message:
Ensure that btree sort ordering functions and boolean comparison operators
give consistent results for all datatypes. Types float4, float8, and
numeric were broken for NaN values; abstime, timestamp, and interval
were broken for INVALID values; timetz was just plain broken (some
possible pairs of values were neither < nor = nor >). Also clean up
text, bpchar, varchar, and bit/varbit to eliminate duplicate code and
thereby reduce the probability of similar inconsistencies arising in
the future.