pgsql/src backend/access/nbtree/nbtcompare.c b ...
pgsql/src backend/access/nbtree/nbtcompare.c b ...
От:
Tom Lane <tgl@hub.org>
Дата:
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.