Commit46517f6

committed

doc: mention that to_char() values are rounded

Reported-by: barsikdacat@gmail.comDiagnosed-by: Laurenz AlbeDiscussion:https://postgr.es/m/168991536429.626.9957835774751337210@wrigleys.postgresql.orgAuthor: Laurenz AlbeBackpatch-through: 11

1 parent77644ad commit46517f6Copy full SHA for 46517f6

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -7899,6 +7899,14 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`7899`	`7899`	`</para>`
`7900`	`7900`	`</listitem>`
`7901`	`7901`
	`7902`	`+ <listitem>`
	`7903`	`+ <para>`
	`7904`	`+ If the format provides fewer fractional digits than the number being`
	`7905`	`+ formatted, <function>to_char()</function> will round the number to`
	`7906`	`+ the specified number of fractional digits.`
	`7907`	`+ </para>`
	`7908`	`+ </listitem>`
	`7909`	`+`
`7902`	`7910`	`<listitem>`
`7903`	`7911`	`<para>`
`7904`	`7912`	`The pattern characters <literal>S</literal>, <literal>L</literal>, <literal>D</literal>,`

Comments

(0)