Re: Table 9.31. to_char Examples

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "y(dot)saburov(at)gmail(dot)com" <y(dot)saburov(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Table 9.31. to_char Examples
Date: 2026-09-28 19:05:59
Message-ID: CAKFQuwZ5zQzv1uyoH1UD5ETb7+ArqF2zNXVU4Et+b0_E8bS2sQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Monday, September 28, 2026, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/18/functions-matching.html
> Description:
>
> This is not true:
>
> ```html
> to_char(485, 'PL999') '+485'
> ```
>

You are correct. As a practical matter there will always be a space after
the plus sign since the formatting code seems to consumes two places. This
may arguably be a bug, but at this point we should just document the
behavior we have.

David J.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2026-09-28 19:25:13 Re: [Minor] Wording in "2.2. Concepts"
Previous Message PG Doc comments form 2026-09-28 15:04:28 [Minor] Conflicting sentence in "2.4. Populating a Table With Rows"