pgsql/src backend/access/nbtree/nbtcompare.c b ...

CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)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.