Add a new GUC variable called "IntervalStyle" that decouples interval output
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Nov 2008 00:28:35 +0000 (00:28 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Nov 2008 00:28:35 +0000 (00:28 +0000)
commitf88970d3c6fb9f99543d873bb7228f4c057c23e0
treedeab16a92ed73da23b08226e09780c104dd7915a
parent12f8bd823daf0f4b0d984d35b35300acc51e554c
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
18 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/datatype.sgml
doc/src/sgml/libpq.sgml
doc/src/sgml/protocol.sgml
doc/src/sgml/ref/copy.sgml
src/backend/utils/adt/datetime.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/timestamp.c
src/backend/utils/init/globals.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/bin/pg_dump/pg_dump.c
src/bin/psql/tab-complete.c
src/include/miscadmin.h
src/interfaces/libpq/fe-connect.c
src/test/regress/expected/interval.out
src/test/regress/pg_regress.c
src/test/regress/sql/interval.sql