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

Commitf04080d

Browse files
committed
Word wrap entry
1 parentc880f9a commitf04080d

File tree

2 files changed

+32
-32
lines changed

2 files changed

+32
-32
lines changed

‎doc/TODO

Lines changed: 16 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated:Mon Apr 24 20:00:38 EDT 2006
5+
Last updated:Mon Apr 24 20:06:13 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -244,24 +244,24 @@ Data Types
244244
o Support ISO INTERVAL syntax if units cannot be determined from
245245
the string, and are supplied after the string
246246

247-
The SQL standard states that the units after the string specify
248-
the units of the string, e.g. INTERVAL '2' MINUTE should
249-
return '00:02:00'. The current behavior has the units
250-
restrict the interval value to the specified unit or unit range,
251-
INTERVAL '70' SECOND returns '00:00:10'.
247+
The SQL standard states that the units after the string
248+
specifythe units of the string, e.g. INTERVAL '2' MINUTE
249+
shouldreturn '00:02:00'. The current behavior has the units
250+
restrict the interval value to the specified unit or unit
251+
range,INTERVAL '70' SECOND returns '00:00:10'.
252252

253253
For syntax that isn't uniquely ISO or PG syntax, like '1' or
254254
'1:30', treat as ISO if there is a range specification clause,
255-
and as PG if there no clause is present, e.g. interpret
256-
'1:30'MINUTE TO SECOND as '1 minute 30 seconds', and
257-
interpret'1:30' as '1 hour, 30 minutes'.
258-
259-
This makes common cases like SELECT INTERVAL '1' MONTH
260-
SQL-standard results.The SQL standard supports a limited
261-
number of unit combinations and doesn't support unit names
262-
inthe string.The PostgreSQL syntax is more flexible in
263-
therange of units supported, e.g. PostgreSQL supports
264-
'1 year 1hour', while the SQL standard does not.
255+
and as PG if there no clause is present, e.g. interpret '1:30'
256+
MINUTE TO SECOND as '1 minute 30 seconds', and interpret
257+
'1:30' as '1 hour, 30 minutes'.
258+
259+
This makes common cases like SELECT INTERVAL '1' MONTH
260+
SQL-standard results. The SQL standard supports a limited
261+
number of unit combinations and doesn't support unit names in
262+
the string. The PostgreSQL syntax is more flexible in the
263+
range of units supported, e.g. PostgreSQL supports'1 year 1
264+
hour', while the SQL standard does not.
265265

266266
o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
267267
o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS

‎doc/src/FAQ/TODO.html

Lines changed: 16 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Mon Apr 24 20:00:38 EDT 2006
11+
Last updated: Mon Apr 24 20:06:13 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -225,24 +225,24 @@ <h1><a name="section_4">Data Types</a></h1>
225225
SECOND
226226
</li><li>Support ISO INTERVAL syntax if units cannot be determined from
227227
the string, and are supplied after the string
228-
<p> The SQL standard states that the units after the string specify
229-
the units of the string, e.g. INTERVAL '2' MINUTE should
230-
return '00:02:00'. The current behavior has the units
231-
restrict the interval value to the specified unit or unit range,
232-
INTERVAL '70' SECOND returns '00:00:10'.
228+
<p> The SQL standard states that the units after the string
229+
specifythe units of the string, e.g. INTERVAL '2' MINUTE
230+
shouldreturn '00:02:00'. The current behavior has the units
231+
restrict the interval value to the specified unit or unit
232+
range,INTERVAL '70' SECOND returns '00:00:10'.
233233
</p>
234234
<p> For syntax that isn't uniquely ISO or PG syntax, like '1' or
235235
'1:30', treat as ISO if there is a range specification clause,
236-
and as PG if there no clause is present, e.g. interpret
237-
'1:30'MINUTE TO SECOND as '1 minute 30 seconds', and
238-
interpret'1:30' as '1 hour, 30 minutes'.
239-
</p>
240-
<p> This makes common cases like SELECT INTERVAL '1' MONTH
241-
SQL-standard results.The SQL standard supports a limited
242-
number of unit combinations and doesn't support unit names
243-
inthe string.The PostgreSQL syntax is more flexible in
244-
therange of units supported, e.g. PostgreSQL supports
245-
'1 year 1hour', while the SQL standard does not.
236+
and as PG if there no clause is present, e.g. interpret '1:30'
237+
MINUTE TO SECOND as '1 minute 30 seconds', and interpret
238+
'1:30' as '1 hour, 30 minutes'.
239+
</p>
240+
<p> This makes common cases like SELECT INTERVAL '1' MONTH
241+
SQL-standard results. The SQL standard supports a limited
242+
number of unit combinations and doesn't support unit names in
243+
the string. The PostgreSQL syntax is more flexible in the
244+
range of units supported, e.g. PostgreSQL supports'1 year 1
245+
hour', while the SQL standard does not.
246246
</p>
247247
</li><li>Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
248248
</li><li>Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp