Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3086f6e

Browse files
committed
Add additional example for interval multiplication.
Fix example for day and hours interval subtraction for new computationmethod.Update interval examples to display zero seconds, which is our default.Backpatch to 8.1.X.
1 parent7ac8a4b commit3086f6e

File tree

1 file changed

+22
-16
lines changed

1 file changed

+22
-16
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 22 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.298 2005/12/11 10:54:27 neilc Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.299 2005/12/21 16:02:24 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -5120,37 +5120,37 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
51205120
<row>
51215121
<entry> <literal>+</literal> </entry>
51225122
<entry><literal>date '2001-09-28' + interval '1 hour'</literal></entry>
5123-
<entry><literal>timestamp '2001-09-28 01:00'</literal></entry>
5123+
<entry><literal>timestamp '2001-09-28 01:00:00'</literal></entry>
51245124
</row>
51255125

51265126
<row>
51275127
<entry> <literal>+</literal> </entry>
51285128
<entry><literal>date '2001-09-28' + time '03:00'</literal></entry>
5129-
<entry><literal>timestamp '2001-09-28 03:00'</literal></entry>
5129+
<entry><literal>timestamp '2001-09-28 03:00:00'</literal></entry>
51305130
</row>
51315131

51325132
<row>
51335133
<entry> <literal>+</literal> </entry>
51345134
<entry><literal>interval '1 day' + interval '1 hour'</literal></entry>
5135-
<entry><literal>interval '1 day 01:00'</literal></entry>
5135+
<entry><literal>interval '1 day 01:00:00'</literal></entry>
51365136
</row>
51375137

51385138
<row>
51395139
<entry> <literal>+</literal> </entry>
51405140
<entry><literal>timestamp '2001-09-28 01:00' + interval '23 hours'</literal></entry>
5141-
<entry><literal>timestamp '2001-09-29 00:00'</literal></entry>
5141+
<entry><literal>timestamp '2001-09-29 00:00:00'</literal></entry>
51425142
</row>
51435143

51445144
<row>
51455145
<entry> <literal>+</literal> </entry>
51465146
<entry><literal>time '01:00' + interval '3 hours'</literal></entry>
5147-
<entry><literal>time '04:00'</literal></entry>
5147+
<entry><literal>time '04:00:00'</literal></entry>
51485148
</row>
51495149

51505150
<row>
51515151
<entry> <literal>-</literal> </entry>
51525152
<entry><literal>- interval '23 hours'</literal></entry>
5153-
<entry><literal>interval '-23:00'</literal></entry>
5153+
<entry><literal>interval '-23:00:00'</literal></entry>
51545154
</row>
51555155

51565156
<row>
@@ -5168,49 +5168,55 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
51685168
<row>
51695169
<entry> <literal>-</literal> </entry>
51705170
<entry><literal>date '2001-09-28' - interval '1 hour'</literal></entry>
5171-
<entry><literal>timestamp '2001-09-27 23:00'</literal></entry>
5171+
<entry><literal>timestamp '2001-09-27 23:00:00'</literal></entry>
51725172
</row>
51735173

51745174
<row>
51755175
<entry> <literal>-</literal> </entry>
51765176
<entry><literal>time '05:00' - time '03:00'</literal></entry>
5177-
<entry><literal>interval '02:00'</literal></entry>
5177+
<entry><literal>interval '02:00:00'</literal></entry>
51785178
</row>
51795179

51805180
<row>
51815181
<entry> <literal>-</literal> </entry>
51825182
<entry><literal>time '05:00' - interval '2 hours'</literal></entry>
5183-
<entry><literal>time '03:00'</literal></entry>
5183+
<entry><literal>time '03:00:00'</literal></entry>
51845184
</row>
51855185

51865186
<row>
51875187
<entry> <literal>-</literal> </entry>
51885188
<entry><literal>timestamp '2001-09-28 23:00' - interval '23 hours'</literal></entry>
5189-
<entry><literal>timestamp '2001-09-28 00:00'</literal></entry>
5189+
<entry><literal>timestamp '2001-09-28 00:00:00'</literal></entry>
51905190
</row>
51915191

51925192
<row>
51935193
<entry> <literal>-</literal> </entry>
51945194
<entry><literal>interval '1 day' - interval '1 hour'</literal></entry>
5195-
<entry><literal>interval '23:00'</literal></entry>
5195+
<entry><literal>interval '1 day -01:00:00'</literal></entry>
51965196
</row>
51975197

51985198
<row>
51995199
<entry> <literal>-</literal> </entry>
52005200
<entry><literal>timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'</literal></entry>
5201-
<entry><literal>interval '1 day 15:00'</literal></entry>
5201+
<entry><literal>interval '1 day 15:00:00'</literal></entry>
52025202
</row>
52035203

52045204
<row>
52055205
<entry> <literal>*</literal> </entry>
5206-
<entry><literal>interval '1 hour' * double precision '3.5'</literal></entry>
5207-
<entry><literal>interval '03:30'</literal></entry>
5206+
<entry><literal>900 * interval '1 second'</literal></entry>
5207+
<entry><literal>interval '00:15:00'</literal></entry>
5208+
</row>
5209+
5210+
<row>
5211+
<entry> <literal>*</literal> </entry>
5212+
<entry><literal>double precision '3.5' * interval '1 hour'</literal></entry>
5213+
<entry><literal>interval '03:30:00'</literal></entry>
52085214
</row>
52095215

52105216
<row>
52115217
<entry> <literal>/</literal> </entry>
52125218
<entry><literal>interval '1 hour' / double precision '1.5'</literal></entry>
5213-
<entry><literal>interval '00:40'</literal></entry>
5219+
<entry><literal>interval '00:40:00'</literal></entry>
52145220
</row>
52155221
</tbody>
52165222
</tgroup>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp