]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Ensure that btree sort ordering functions and boolean comparison operators
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 3 May 2001 19:00:37 +0000 (19:00 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 3 May 2001 19:00:37 +0000 (19:00 +0000)
commit2792374cff361a7a4ec0e750b5fa935d85afc9ac
tree98736405bf8af30af89bdf224802f868057b7d2a
parent77fe28f33e49d752be4e4a1bbc6c112f825e7882
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.
13 files changed:
src/backend/access/nbtree/nbtcompare.c
src/backend/utils/adt/date.c
src/backend/utils/adt/float.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/numeric.c
src/backend/utils/adt/timestamp.c
src/backend/utils/adt/varbit.c
src/backend/utils/adt/varchar.c
src/backend/utils/adt/varlena.c
src/include/utils/nabstime.h
src/test/regress/expected/abstime-solaris-1947.out
src/test/regress/expected/abstime.out
src/test/regress/expected/timestamp.out