pgsql: Allow times of 24:00:00 to match rounding behavior:

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)

Browse pgsql-committers by date

  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.