Commit253bc4e

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 parent3ddc889 commit253bc4eCopy full SHA for 253bc4e

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -8505,6 +8505,14 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`8505`	`8505`	`</para>`
`8506`	`8506`	`</listitem>`
`8507`	`8507`
	`8508`	`+ <listitem>`
	`8509`	`+ <para>`
	`8510`	`+ If the format provides fewer fractional digits than the number being`
	`8511`	`+ formatted, <function>to_char()</function> will round the number to`
	`8512`	`+ the specified number of fractional digits.`
	`8513`	`+ </para>`
	`8514`	`+ </listitem>`
	`8515`	`+`
`8508`	`8516`	`<listitem>`
`8509`	`8517`	`<para>`
`8510`	`8518`	`The pattern characters <literal>S</literal>, <literal>L</literal>, <literal>D</literal>,`

Comments

(0)