Commit18aecf5

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 parentde35fb8 commit18aecf5Copy full SHA for 18aecf5

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -8446,6 +8446,14 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`8446`	`8446`	`</para>`
`8447`	`8447`	`</listitem>`
`8448`	`8448`
	`8449`	`+ <listitem>`
	`8450`	`+ <para>`
	`8451`	`+ If the format provides fewer fractional digits than the number being`
	`8452`	`+ formatted, <function>to_char()</function> will round the number to`
	`8453`	`+ the specified number of fractional digits.`
	`8454`	`+ </para>`
	`8455`	`+ </listitem>`
	`8456`	`+`
`8449`	`8457`	`<listitem>`
`8450`	`8458`	`<para>`
`8451`	`8459`	`The pattern characters <literal>S</literal>, <literal>L</literal>, <literal>D</literal>,`

Comments

(0)