diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-10-14 11:47:57 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-10-14 11:47:57 +0000 |
| commit | a93bf4503ffc6d7cd6243a6324fb2ef206b10adf (patch) | |
| tree | b42cbc485e4250d2b1116ac9e52a5ac94f7d1d5f /doc/src | |
| parent | dbc214f7e611ed32bd8208955486ba46d2dbc941 (diff) | |
| download | postgresql-a93bf4503ffc6d7cd6243a6324fb2ef206b10adf.tar.gz postgresql-a93bf4503ffc6d7cd6243a6324fb2ef206b10adf.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 48caaa2994f..0d4819e8094 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.160 2005/10/02 23:50:06 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.161 2005/10/14 11:47:56 momjian Exp $ --> <chapter id="datatype"> @@ -1368,7 +1368,7 @@ SELECT b, char_length(b) FROM test2; <entry>8 bytes</entry> <entry>times of day only</entry> <entry>00:00:00.00</entry> - <entry>23:59:59.99</entry> + <entry>24:00:00</entry> <entry>1 microsecond / 14 digits</entry> </row> <row> @@ -1376,7 +1376,7 @@ SELECT b, char_length(b) FROM test2; <entry>12 bytes</entry> <entry>times of day only, with time zone</entry> <entry>00:00:00.00+12</entry> - <entry>23:59:59.99-12</entry> + <entry>24:00:00-12</entry> <entry>1 microsecond / 14 digits</entry> </row> </tbody> |