| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | y(dot)saburov(at)gmail(dot)com |
| Subject: | Table 9.31. to_char Examples |
| Date: | 2026-09-28 14:26:06 |
| Message-ID: | 179060556683.1026193.5885759110394852468@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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'
```
add examples:
```psql
db=# SELECT quote_literal(to_char(timestamp '2026-04-15','RM'));
quote_literal
---------------
'IV '
(1 рядок)
db=# SELECT quote_literal(to_char(timestamp '2026-04-15','FMRM'));
quote_literal
---------------
'IV'
(1 рядок)
db=# SELECT quote_literal(to_char(timestamp '2026-12-31', 'rm'));
quote_literal
---------------
'xii '
(1 рядок)
```
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2026-09-28 14:42:55 | [Minor] Wording in "2.2. Concepts" |
| Previous Message | Matemática A3K | 2026-09-28 12:56:46 | Re: Possible command-injection or meta-command execution in `psql` input |