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

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.