Обсуждение: pgsql: Add a new GUC variable called "IntervalStyle" that decouples

Поиск
Список
Период
Сортировка

pgsql: Add a new GUC variable called "IntervalStyle" that decouples

От
tgl@postgresql.org (Tom Lane)
Дата:
Log Message:
-----------
Add a new GUC variable called "IntervalStyle" that decouples interval output
from DateStyle, and create a new interval style that produces output matching
the SQL standard (at least for interval values that fall within the standard's
restrictions).  IntervalStyle is also used to resolve the conflict between the
standard and traditional Postgres rules for interpreting negative interval
input.

Ron Mayer

Modified Files:
--------------
    pgsql/doc/src/sgml:
        config.sgml (r1.193 -> r1.194)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.193&r2=1.194)
        datatype.sgml (r1.231 -> r1.232)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml?r1=1.231&r2=1.232)
        libpq.sgml (r1.267 -> r1.268)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml?r1=1.267&r2=1.268)
        protocol.sgml (r1.74 -> r1.75)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/protocol.sgml?r1=1.74&r2=1.75)
    pgsql/doc/src/sgml/ref:
        copy.sgml (r1.82 -> r1.83)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/copy.sgml?r1=1.82&r2=1.83)
    pgsql/src/backend/utils/adt:
        datetime.c (r1.196 -> r1.197)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c?r1=1.196&r2=1.197)
        nabstime.c (r1.156 -> r1.157)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/nabstime.c?r1=1.156&r2=1.157)
        timestamp.c (r1.193 -> r1.194)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c?r1=1.193&r2=1.194)
    pgsql/src/backend/utils/init:
        globals.c (r1.105 -> r1.106)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/globals.c?r1=1.105&r2=1.106)
    pgsql/src/backend/utils/misc:
        guc.c (r1.475 -> r1.476)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.475&r2=1.476)
        postgresql.conf.sample (r1.246 -> r1.247)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample?r1=1.246&r2=1.247)
    pgsql/src/bin/pg_dump:
        pg_dump.c (r1.503 -> r1.504)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.503&r2=1.504)
    pgsql/src/bin/psql:
        tab-complete.c (r1.174 -> r1.175)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c?r1=1.174&r2=1.175)
    pgsql/src/include:
        miscadmin.h (r1.203 -> r1.204)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/miscadmin.h?r1=1.203&r2=1.204)
    pgsql/src/interfaces/libpq:
        fe-connect.c (r1.366 -> r1.367)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-connect.c?r1=1.366&r2=1.367)
    pgsql/src/test/regress/expected:
        interval.out (r1.23 -> r1.24)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/interval.out?r1=1.23&r2=1.24)
    pgsql/src/test/regress:
        pg_regress.c (r1.48 -> r1.49)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/pg_regress.c?r1=1.48&r2=1.49)
    pgsql/src/test/regress/sql:
        interval.sql (r1.15 -> r1.16)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/interval.sql?r1=1.15&r2=1.16)