Re: 4.1.4. Special Characters

From: Arvind Kandpal <arvind(dot)kandpal(at)ksolves(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: 4.1.4. Special Characters
Date: 2026-10-28 08:15:00
Message-ID: CAM_z12h8-PqFWi7x-i8ePZfM4=HjhtzFhi-zfKMbF=tRETTe8g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

The attached patch adds a sentence to the asterisk item in section
4.1.4, saying that system columns are not included in * and must be
selected by name, with the suggested example and a link to the System
Columns section.

I built the docs locally (make check and make html) and the new text
and link render fine.

Thanks & Regards,

On Wed, Oct 28, 2026 at 1:40 PM 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/sql-syntax-lexical.html
> Description:
>
> >> The asterisk (*) is used in some contexts to denote all the fields of a
> table row or composite value.
>
> As for Postgres specifically, you can add an example like `SELECT ctid, *
> FROM t;` and a link to Section 5.6, “System Columns.”
>
>
>
>
>

--
Arvind Kandpal
Junior Software Engineer
(+91) 9650266413 www.ksolves.com

Years of
listing on

Attachment Content-Type Size
v1-0001-doc-Mention-that-does-not-include-system-columns.patch application/x-patch 1.3 KB

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2026-10-28 10:02:12 Re: 4.1.4. Special Characters
Previous Message Bruce Momjian 2026-10-27 22:33:24 Re: Fix sequence membership command in PG19 release notes