Add timestamp-versus-timestamptz cross-type comparison functions,
Tom Lane <tgl@sss.pgh.pa.us>
Add timestamp-versus-timestamptz cross-type comparison functions, flesh out the index operator classes to include these. In passing, fix erroneous volatility marking of ACL functions.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/timestamp.c | modified | +183 −2 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_amop.h | modified | +13 −1 |
| src/include/catalog/pg_amproc.h | modified | +3 −1 |
| src/include/catalog/pg_operator.h | modified | +21 −5 |
| src/include/catalog/pg_proc.h | modified | +38 −6 |
| src/include/utils/timestamp.h | modified | +17 −1 |
| src/test/regress/expected/opr_sanity.out | modified | +44 −0 |
| src/test/regress/sql/opr_sanity.sql | modified | +34 −0 |