| From: | Hoda Salim <hoda(dot)s(dot)salim(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | [PATCH] docs: document N'...' national character string literal syntax |
| Date: | 2026-02-02 15:05:03 |
| Message-ID: | CAAGT0iKc1Fq=mmK99fMd8O+QGZfCAqzx3bOWBcci6fO8SjLGtQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Hi,
This patch documents the N'...' national character string literal
syntax, which has been supported by PostgreSQL but was previously
undocumented.
The documentation explains:
- What the syntax is (N'hello')
- What the SQL standard specifies (implementation-defined national
character set)
- What PostgreSQL actually does (treats it as a cast to character type)
- Why it exists (compatibility with SQL migrated from other databases)
I verified the documentation builds without errors.
--
Hoda Salim
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-docs-document-N-national-character-string-literal.patch | application/octet-stream | 3.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yahya Yusuf | 2026-02-02 17:06:18 | Proposal: HOT Update Runtime Check Clarification |
| Previous Message | PG Doc comments form | 2026-02-02 09:07:41 | OS system version upgrade (glibc / libicu version change) |