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

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a new GUC variable called "IntervalStyle" that decouples
Date: 2008-11-09 00:28:36
Message-ID: 20081109002836.254D17545A4@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2008-11-09 17:09:49 pgsql: Add some documentation about handling of fractions in interval
Previous Message Tom Lane 2008-11-08 20:51:50 pgsql: Fix recently added code for SQL years-months interval syntax so