Log Message: ----------- 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. Modified Files: -------------- pgsql-server/doc/src/sgml: func.sgml (r1.212 -> r1.213) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/func.sgml.diff?r1=1.212&r2=1.213) pgsql-server/src/backend/utils/adt: date.c (r1.99 -> r1.100) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/date.c.diff?r1=1.99&r2=1.100) pgsql-server/src/include/catalog: catversion.h (r1.242 -> r1.243) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/catversion.h.diff?r1=1.242&r2=1.243) pg_operator.h (r1.125 -> r1.126) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/pg_operator.h.diff?r1=1.125&r2=1.126) pg_proc.h (r1.340 -> r1.341) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/pg_proc.h.diff?r1=1.340&r2=1.341) pgsql-server/src/include/utils: date.h (r1.26 -> r1.27) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/utils/date.h.diff?r1=1.26&r2=1.27) pgsql-server/src/test/regress/expected: horology.out (r1.50 -> r1.51) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/expected/horology.out.diff?r1=1.50&r2=1.51) pgsql-server/src/test/regress/sql: horology.sql (r1.28 -> r1.29) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/sql/horology.sql.diff?r1=1.28&r2=1.29)
pgsql-committers by date:
Соглашаюсь с условиями обработки персональных данных