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

Commitfbbd7ed

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 parent26f36fe commitfbbd7ed

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
@@ -9914,11 +9914,11 @@ SELECT timestamp with time zone '2005-04-02 12:00:00-07' + interval '24 hours';
99149914
<screen>
99159915
SELECT EXTRACT(EPOCH FROM timestamptz '2013-07-01 12:00:00') -
99169916
EXTRACT(EPOCH FROM timestamptz '2013-03-01 12:00:00');
9917-
<lineannotation>Result: </lineannotation><computeroutput>10537200</computeroutput>
9917+
<lineannotation>Result: </lineannotation><computeroutput>10537200.000000</computeroutput>
99189918
SELECT (EXTRACT(EPOCH FROM timestamptz '2013-07-01 12:00:00') -
99199919
EXTRACT(EPOCH FROM timestamptz '2013-03-01 12:00:00'))
99209920
/ 60 / 60 / 24;
9921-
<lineannotation>Result: </lineannotation><computeroutput>121.958333333333</computeroutput>
9921+
<lineannotation>Result: </lineannotation><computeroutput>121.9583333333333333</computeroutput>
99229922
SELECT timestamptz '2013-07-01 12:00:00' - timestamptz '2013-03-01 12:00:00';
99239923
<lineannotation>Result: </lineannotation><computeroutput>121 days 23:00:00</computeroutput>
99249924
SELECT age(timestamptz '2013-07-01 12:00:00', timestamptz '2013-03-01 12:00:00');
@@ -10064,13 +10064,13 @@ SELECT EXTRACT(DOY FROM TIMESTAMP '2001-02-16 20:38:40');
1006410064

1006510065
<screen>
1006610066
SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40.12-08');
10067-
<lineannotation>Result: </lineannotation><computeroutput>982384720.12</computeroutput>
10067+
<lineannotation>Result: </lineannotation><computeroutput>982384720.120000</computeroutput>
1006810068

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

1007210072
SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
10073-
<lineannotation>Result: </lineannotation><computeroutput>442800</computeroutput>
10073+
<lineannotation>Result: </lineannotation><computeroutput>442800.000000</computeroutput>
1007410074
</screen>
1007510075

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

1021810218
<screen>
1021910219
SELECT EXTRACT(MILLISECONDS FROM TIME '17:12:28.5');
10220-
<lineannotation>Result: </lineannotation><computeroutput>28500</computeroutput>
10220+
<lineannotation>Result: </lineannotation><computeroutput>28500.000</computeroutput>
1022110221
</screen>
1022210222
</listitem>
1022310223
</varlistentry>
@@ -10281,10 +10281,10 @@ SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-02-16 20:38:40');
1028110281

1028210282
<screen>
1028310283
SELECT EXTRACT(SECOND FROM TIMESTAMP '2001-02-16 20:38:40');
10284-
<lineannotation>Result: </lineannotation><computeroutput>40</computeroutput>
10284+
<lineannotation>Result: </lineannotation><computeroutput>40.000000</computeroutput>
1028510285

1028610286
SELECT EXTRACT(SECOND FROM TIME '17:12:28.5');
10287-
<lineannotation>Result: </lineannotation><computeroutput>28.5</computeroutput>
10287+
<lineannotation>Result: </lineannotation><computeroutput>28.500000</computeroutput>
1028810288
</screen>
1028910289
</listitem>
1029010290
</varlistentry>

0 commit comments

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