OSDN Git Service

Add missing operators of the form interval-plus-datetime, as required for
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 2 Jul 2004 22:50:23 +0000 (22:50 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 2 Jul 2004 22:50:23 +0000 (22:50 +0000)
commite34082ee3b07c0cf483e0bc5b8e25cc882e19ddc
tree39b35a9041aaa1da930c1702ce434e175d3a029c
parent0b89d261c7a91ff9ebc6a6b9bd3ee129576bdd9a
Add missing operators of the form interval-plus-datetime, as required for
better SQL compliance in this area, per recent discussion.  Mark related
operators as commutators where possible.  (The system doesn't actually care
about commutator marking for operators not returning boolean, at the moment,
but this seems forward-thinking and besides it made it easier to verify
that we hadn't missed any.)
Also, remove interval-minus-time and interval-minus-timetz operators.
I'm not sure how these got in, but they are nonstandard and had very
obviously broken behavior.  (minus is not commutative in anyone's book.)
I doubt anyone had ever used 'em, because we'd surely have gotten a bug
report about it if so.
doc/src/sgml/func.sgml
src/backend/utils/adt/date.c
src/include/catalog/catversion.h
src/include/catalog/pg_operator.h
src/include/catalog/pg_proc.h
src/include/utils/date.h
src/test/regress/expected/horology.out
src/test/regress/sql/horology.sql