"Dennis Vshivkov" <[EMAIL PROTECTED]> writes:
> [8.0.1|src/backend/utils/adt/date.c] timetz_cmp_internal():
> /* Primary sort is by true (GMT-equivalent) time */
> t1 = time1->time + time1->zone;
> t2 = time2->time + time2->zone;
> This code is only valid when HAVE_INT64_TIMESTAMP is NOT the case.
Fixed, thanks for the report.
Note that this fix will invalidate any existing indexes on TIMETZ
columns in --enable-integer-datetimes installations; they'll have
to be REINDEXed after application of the patch. I suspect such
indexes are pretty few and far between, so I went ahead and back-patched
the fix into back branches despite the risk of incompatibility.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
