Skip to content

Commit 6020078

Browse files
committed
Convert explanation of interval change into something resembling grammatical
English, and fix the incorrect example.
1 parent 6a9b93a commit 6020078

File tree

1 file changed

+13
-12
lines changed

1 file changed

+13
-12
lines changed

doc/src/sgml/release.sgml

Lines changed: 13 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.392 2005/10/25 15:12:22 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.393 2005/10/25 17:54:30 tgl Exp $
33

44
Typical markup:
55

@@ -1147,7 +1147,7 @@ psql -t -f fixseq.sql db1 | psql -e db1
11471147
SELECT CURRENT_TIMESTAMP AT TIME ZONE 'Europe/London';
11481148
</programlisting>
11491149
In the above query, the time zone used is adjusted based on the
1150-
daylight savings time rules that were in effect on the supplied
1150+
daylight saving time rules that were in effect on the supplied
11511151
date.
11521152
</para>
11531153
</listitem>
@@ -1206,21 +1206,22 @@ psql -t -f fixseq.sql db1 | psql -e db1
12061206

12071207
<listitem>
12081208
<para>
1209-
Add an internal day field to <type>INTERVAL</> so a one day
1209+
Add a separate day field to type <type>interval</> so a one day
12101210
interval can be distinguished from a 24 hour interval (Michael
12111211
Glaesemann)
12121212
</para>
12131213
<para>
1214-
Dates that contain a daylight savings time adjustment are not 24
1215-
hours, but typically 23 or 25 hours. This change allows numeric days
1216-
(not fixed 24-hour periods) to be added to dates which include
1217-
a daylight savings time adjustment period. Therefore, while in
1218-
previous releases <literal>1 day</> and <literal>24 hours</> were
1219-
interchangeable interval values, in this release they are treated
1220-
differently, e.g.
1214+
Days that contain a daylight saving time adjustment are not 24
1215+
hours long, but typically 23 or 25 hours. This change creates a
1216+
conceptual distinction between intervals of <quote>so many days</>
1217+
and intervals of <quote>so many hours</>. Adding
1218+
<literal>1 day</> to a timestamp now gives the same local time on
1219+
the next day even if a daylight saving time adjustment occurs
1220+
between, whereas adding <literal>24 hours</> will give a different
1221+
local time when this happens. For example, under US DST rules:
12211222
<programlisting>
1222-
'2005-05-03 00:00:00 EST' + '1 day' = '2005-05-04 00:00:00-04'
1223-
'2005-05-03 00:00:00 EST' + '24 hours' = '2005-05-04 01:00:00-04'
1223+
'2005-04-03 00:00:00-05' + '1 day' = '2005-04-04 00:00:00-04'
1224+
'2005-04-03 00:00:00-05' + '24 hours' = '2005-04-04 01:00:00-04'
12241225
</programlisting>
12251226
</para>
12261227
</listitem>

0 commit comments

Comments
 (0)