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

Commit707691e

Browse files
committed
Doc: adjust examples of EXTRACT() output to match current reality.
EXTRACT(EPOCH), EXTRACT(SECOND), and some related cases print moretrailing zeroes than they used to. This behavior change happenedwith commita2da77c (Change return type of EXTRACT to numeric),and it was intentional according to the commit log: - Return values when extracting fields with possibly fractional values, such as second and epoch, now have the full scale that the value has internally (so, for example, '1.000000' instead of just '1').It's been like that for two releases now, so while I suggestedchanging this back, it's probably better to adjust the documentationexamples.Per bug #17866 from Евгений Жужнев. Back-patch to v14 where thechange came in.Discussion:https://postgr.es/m/17866-18eb70095b1594e2@postgresql.org
1 parentced712f commit707691e

File tree

1 file changed

+8
-8
lines changed

1 file changed

+8
-8
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -9801,11 +9801,11 @@ SELECT timestamp with time zone '2005-04-02 12:00:00-07' + interval '24 hours';
98019801
<screen>
98029802
SELECT EXTRACT(EPOCH FROM timestamptz '2013-07-01 12:00:00') -
98039803
EXTRACT(EPOCH FROM timestamptz '2013-03-01 12:00:00');
9804-
<lineannotation>Result: </lineannotation><computeroutput>10537200</computeroutput>
9804+
<lineannotation>Result: </lineannotation><computeroutput>10537200.000000</computeroutput>
98059805
SELECT (EXTRACT(EPOCH FROM timestamptz '2013-07-01 12:00:00') -
98069806
EXTRACT(EPOCH FROM timestamptz '2013-03-01 12:00:00'))
98079807
/ 60 / 60 / 24;
9808-
<lineannotation>Result: </lineannotation><computeroutput>121.958333333333</computeroutput>
9808+
<lineannotation>Result: </lineannotation><computeroutput>121.9583333333333333</computeroutput>
98099809
SELECT timestamptz '2013-07-01 12:00:00' - timestamptz '2013-03-01 12:00:00';
98109810
<lineannotation>Result: </lineannotation><computeroutput>121 days 23:00:00</computeroutput>
98119811
SELECT age(timestamptz '2013-07-01 12:00:00', timestamptz '2013-03-01 12:00:00');
@@ -9951,13 +9951,13 @@ SELECT EXTRACT(DOY FROM TIMESTAMP '2001-02-16 20:38:40');
99519951

99529952
<screen>
99539953
SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40.12-08');
9954-
<lineannotation>Result: </lineannotation><computeroutput>982384720.12</computeroutput>
9954+
<lineannotation>Result: </lineannotation><computeroutput>982384720.120000</computeroutput>
99559955

99569956
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40.12');
9957-
<lineannotation>Result: </lineannotation><computeroutput>982355920.12</computeroutput>
9957+
<lineannotation>Result: </lineannotation><computeroutput>982355920.120000</computeroutput>
99589958

99599959
SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
9960-
<lineannotation>Result: </lineannotation><computeroutput>442800</computeroutput>
9960+
<lineannotation>Result: </lineannotation><computeroutput>442800.000000</computeroutput>
99619961
</screen>
99629962

99639963
<para>
@@ -10104,7 +10104,7 @@ SELECT EXTRACT(MILLENNIUM FROM TIMESTAMP '2001-02-16 20:38:40');
1010410104

1010510105
<screen>
1010610106
SELECT EXTRACT(MILLISECONDS FROM TIME '17:12:28.5');
10107-
<lineannotation>Result: </lineannotation><computeroutput>28500</computeroutput>
10107+
<lineannotation>Result: </lineannotation><computeroutput>28500.000</computeroutput>
1010810108
</screen>
1010910109
</listitem>
1011010110
</varlistentry>
@@ -10168,10 +10168,10 @@ SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-02-16 20:38:40');
1016810168

1016910169
<screen>
1017010170
SELECT EXTRACT(SECOND FROM TIMESTAMP '2001-02-16 20:38:40');
10171-
<lineannotation>Result: </lineannotation><computeroutput>40</computeroutput>
10171+
<lineannotation>Result: </lineannotation><computeroutput>40.000000</computeroutput>
1017210172

1017310173
SELECT EXTRACT(SECOND FROM TIME '17:12:28.5');
10174-
<lineannotation>Result: </lineannotation><computeroutput>28.5</computeroutput>
10174+
<lineannotation>Result: </lineannotation><computeroutput>28.500000</computeroutput>
1017510175
</screen>
1017610176
</listitem>
1017710177
</varlistentry>

0 commit comments

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