From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Allow times of 24:00:00 to match rounding behavior: |
Date: | 2005-10-14 11:47:57 |
Message-ID: | 20051014114757.B6584D8FDE@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Allow times of 24:00:00 to match rounding behavior:
regression=# select '23:59:59.9'::time(0);
time
----------
24:00:00
(1 row)
This is bad because:
regression=# select '24:00:00'::time(0);
ERROR: date/time field value out of range: "24:00:00"
The last example now works.
Modified Files:
--------------
pgsql/doc/src/sgml:
datatype.sgml (r1.160 -> r1.161)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml.diff?r1=1.160&r2=1.161)
pgsql/src/backend/utils/adt:
datetime.c (r1.158 -> r1.159)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.158&r2=1.159)
nabstime.c (r1.143 -> r1.144)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/nabstime.c.diff?r1=1.143&r2=1.144)
pgsql/src/interfaces/ecpg/pgtypeslib:
dt_common.c (r1.30 -> r1.31)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/pgtypeslib/dt_common.c.diff?r1=1.30&r2=1.31)
From | Date | Subject | |
---|---|---|---|
Next Message | User Xzilla | 2005-10-14 12:24:43 | wikipedia - wikipgedia: Add a plac e for postgresql specific notes. |
Previous Message | User Bloodnok | 2005-10-14 03:07:55 | veil - veil: Demo installation updates. |