Request a Demo
Home   >   mailing lists

Re: Table 9.31. to_char Examples - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Table 9.31. to_char Examples
Date
Msg-id CAKFQuwZ5zQzv1uyoH1UD5ETb7+ArqF2zNXVU4Et+b0_E8bS2sQ@mail.gmail.com
Whole thread
In response to Table 9.31. to_char Examples  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: Table 9.31. to_char Examples
List pgsql-docs
Tree view
On Monday, September 28, 2026, PG Doc comments form <noreply@postgresql.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.
 

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: [Minor] Clarification on "2.7. Aggregate Functions"
Next
From: Laurenz Albe
Date:
Subject: Re: [Minor] Wording in "2.2. Concepts"