From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ... |
Date: | 2003-12-20 15:32:55 |
Message-ID: | 20031220153255.3B81CD1B46C@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-patches |
CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)svr1(dot)postgresql(dot)org 03/12/20 11:32:55
Modified files:
doc/src/sgml : datatype.sgml
src/backend/commands: variable.c
src/backend/utils/adt: datetime.c
src/include : miscadmin.h
src/interfaces/ecpg/pgtypeslib: dt.h dt_common.c interval.c
Log message:
In my mind there were two categories of open issues
a) ones that are 100% backward (such as the comment about
outputting this format)
and
b) ones that aren't (such as deprecating the current
postgresql shorthand of
'1Y1M'::interval = 1 year 1 minute
in favor of the ISO-8601
'P1Y1M'::interval = 1 year 1 month.
Attached is a patch that addressed all the discussed issues that
did not break backward compatability, including the ability to
output ISO-8601 compliant intervals by setting datestyle to
iso8601basic.
Interval values can now be written as ISO 8601 time intervals, using
the "Format with time-unit designators". This format always starts with
the character 'P', followed by a string of values followed
by single character time-unit designators. A 'T' separates the date and
time parts of the interval.
Ron Mayer
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-12-20 15:59:25 | pgsql-server/doc/src/sgml datatype.sgml |
Previous Message | Peter Eisentraut - PostgreSQL | 2003-12-20 15:32:19 | pgsql-server/. Tag: REL7_4_STABLE INSTALL |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-12-20 17:33:22 | Re: fork/exec patch |
Previous Message | Bruce Momjian | 2003-12-20 15:32:45 | Re: ISO 8601 "Time Intervals" of the "format with time-unit |