Movatterモバイル変換

Skip to content

postgrespro/postgresPublic

forked frompostgres/postgres

NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit9d61b99

bmomjian

committed

to_char(float4/8): don't print "junk" digits

Commitcc0d90b also avoids printingjunk digits, which are digits that are beyond the precision of theunderlying type.

1 parentcc0d90b commit9d61b99Copy full SHA for 9d61b99

File tree

2 files changed

+2

-2

lines changed

src/test/regress
- expected
  - numeric.out
- sql
  - numeric.sql

2 files changed

+2

-2

lines changed

`‎src/test/regress/expected/numeric.out`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1539,7 +1539,7 @@ SELECT to_char(float8 '1.123456789123456789', '9.' \|\| repeat('9', 55));`
`1539`	`1539`	`(1 row)`
`1540`	`1540`
`1541`	`1541`	`SELECT to_char(float8 '1999999999999999999999999999999999999999999999.123456789123456789',`
`1542`		`-repeat('9', 50) \|\| '.' \|\| repeat('9', 50));`
	`1542`	`+ repeat('9', 50) \|\| '.' \|\| repeat('9', 50));`
`1543`	`1543`	`to_char`
`1544`	`1544`	`--------------------------------------------------------------------------------------------------------`
`1545`	`1545`	`1999999999999990000000000000000000000000000000.00000000000000000000000000000000000000000000000000`

`‎src/test/regress/sql/numeric.sql`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -870,7 +870,7 @@ SELECT to_char(float8 '1e20','999999999999999999999D9');`
`870`	`870`	`SELECT to_char(1e20,'999999999999999999999D9');`
`871`	`871`	`SELECT to_char(float8'1.123456789123456789','9.'\|\| repeat('9',55));`
`872`	`872`	`SELECT to_char(float8'1999999999999999999999999999999999999999999999.123456789123456789',`
`873`		`-repeat('9',50)\|\|'.'\|\| repeat('9',50));`
	`873`	`+ repeat('9',50)\|\|'.'\|\| repeat('9',50));`
`874`	`874`	`SELECT to_char(float8'0.1','9D'\|\| repeat('9',1000));`
`875`	`875`	`SELECT to_char(int4'1','9D'\|\| repeat('9',1000)\|\|'EEEE');`
`876`	`876`	`SELECT to_char(float4'1','9D'\|\| repeat('9',1000)\|\|'EEEE');`

0 commit comments

Comments

(0)

[8]ページ先頭

©2009-2025 Movatter.jp