Re: 4.1.4. Special Characters

From: Arvind Kandpal <arvind(dot)kandpal(at)ksolves(dot)com>
To: peter(at)eisentraut(dot)org
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: 4.1.4. Special Characters
Date: 2026-11-02 07:54:38
Message-ID: CAM_z12jtJ-G73WueW3h40vv67ZzVrqkOS7hNRE6N=NBEsVJYhQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi Peter,

Following up on the v2 patch I sent to the list on Oct 28, based on your
suggestion to update the SELECT reference page instead of section 4.1.4.
I'm attaching it again here for convenience.

When you have time, could you take a look and let me know if it looks good
or needs any changes?

Thanks and Regards,

On Wed, Oct 28, 2026 at 3:43 PM Arvind Kandpal <arvind(dot)kandpal(at)ksolves(dot)com>
wrote:

> Subject: Re: 4.1.4. Special Characters
>
> On 28.10.26 Peter Eisentraut wrote:
> > I think the section that you are patching is more for roughly mentioning
> > all the possible uses of various characters, but it's not the
> > authoritative source for what all those characters mean in detail in
> > those contexts. Otherwise, this could get out of hand. I would have
> > expected to find that for this particular case on the SELECT reference
> > page, but it's not mentioned there either. Maybe that page should be
> > updated?
>
> Thanks for the review. That makes sense.
>
> The attached v2 drops the change to section 4.1.4 and instead adds a
> sentence to the SELECT List section of the SELECT reference page. It
> says that neither * nor table_name.* includes system columns, which
> must be listed by name, and links to the System Columns section.
>
> The docs build cleanly with make check and make html.
>
> Thanks and Regards,
>
>
> On Wed, Oct 28, 2026 at 3:32 PM Peter Eisentraut <peter(at)eisentraut(dot)org>
> wrote:
> >
> > On 28.10.26 09:15, Arvind Kandpal wrote:
> > > 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.
> >
> > I think the section that you are patching is more for roughly mentioning
> > all the possible uses of various characters, but it's not the
> > authoritative source for what all those characters mean in detail in
> > those contexts. Otherwise, this could get out of hand. I would have
> > expected to find that for this particular case on the SELECT reference
> > page, but it's not mentioned there either. Maybe that page should be
> > updated?
> >
>
>
> --
> Arvind Kandpal
> Junior Software Engineer
> (+91) 9650266413 <+91%2096502%2066413> www.ksolves.com
>
> Years of
> listing on
>

--
[image: Arvind Kandpal]
Arvind Kandpal [image: LinkedIn]
<https://www.linkedin.com/in/arvind-kandpal-4635b1229/>
Junior Software Engineer
[image: Phone] (+91) 9650266413 <(+91)+9650266413> [image: Website]
www.ksolves.com
[image: Great Place to Work] [image: CMMI Level 3] [image: ISO] [image:
Salesforce Summit Partner] [image: Odoo Gold Partner] [image: Figma
Partner]
[image: Ksolves - AI First, Always]
[image: Celebrating]
[image: 6] Years of
listing on
[image: Indian Stock Exchange]

Attachment Content-Type Size
v2-0001-doc-Mention-that-does-not-include-system-columns.patch text/x-patch 1.2 KB

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2026-11-02 17:00:51 Re: postmaster.pid also contains shared memory key
Previous Message Laurenz Albe 2026-11-02 05:05:13 Re: postmaster.pid also contains shared memory key