pgsql-server: Add missing operators of the form interval-plus-datetime,

Поиск
Список
Период
Сортировка
От tgl@svr1.postgresql.org (Tom Lane)
Тема pgsql-server: Add missing operators of the form interval-plus-datetime,
Дата
Msg-id 20040702225026.93E25D1B1A9@svr1.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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 по дате отправления:

Предыдущее
От: joe@svr1.postgresql.org (Joe Conway)
Дата:
Сообщение: pgsql-server: Andreas Pflug wrote: From an idea of Bruce, the attached
Следующее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql-server: Fix no-longer-correct bit-pushing in