pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
4.1.4. Special Characters
10+ messages / 4 participants
[nested] [flat]

* 4.1.4. Special Characters
@ 2026-08-27 08:44 PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  0 siblings, 1 reply; 10+ messages in thread

From: PG Doc comments form @ 2026-08-27 08:44 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org; +Cc: y.saburov@gmail.com

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.”







^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
@ 2026-10-28 08:15 ` Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  0 siblings, 1 reply; 10+ messages in thread

From: Arvind Kandpal @ 2026-10-28 08:15 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org

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@postgresql.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

Attachments:

v1-0001-doc-Mention-that-does-not-include-system-columns.patch (application/x-patch, 1.3K) download From 11ece8b43624801a0f31d1587eb22e395565a292 Mon Sep 17 00:00:00 2001 From: Arvind Kandpal <arvind.kandpal@ksolves.com> Date: Wed, 28 Oct 2026 13:38:26 +0530 Subject: [PATCH v1] doc: Mention that * does not include system columns Point out that system columns must be selected by name, and link to the System Columns section. Discussion: https://postgr.es/m/178782026936.2606573.10270614257871556098@wrigleys.postgresql.org --- doc/src/sgml/syntax.sgml | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index a697218c8b3..f7a4d079512 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -918,7 +918,10 @@ CAST ( '<replaceable>string</replaceable>' AS <replaceable>type</replaceable> ) <listitem> <para> The asterisk (<literal>*</literal>) is used in some contexts to denote - all the fields of a table row or composite value. It also + all the fields of a table row or composite value. System columns + are not included and must be selected by name, as in + <literal>SELECT ctid, * FROM t</literal>. (See <xref + linkend="ddl-system-columns"/>.) The asterisk also has a special meaning when used as the argument of an aggregate function, namely that the aggregate does not require any explicit parameter. -- 2.43.0
^ permalink raw reply [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
@ 2026-10-28 10:02   ` Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Peter Eisentraut @ 2026-10-28 10:02 UTC (permalink / raw)
  To: Arvind Kandpal <arvind.kandpal@ksolves.com>; pgsql-docs@lists.postgresql.org

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?







^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
@ 2026-10-28 10:13     ` Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-02 07:54       ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Arvind Kandpal @ 2026-10-28 10:13 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org

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@eisentraut.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 www.ksolves.com

Years of
listing on

Attachments:

v2-0001-doc-Mention-that-does-not-include-system-columns.patch (text/x-patch, 1.2K) download From 854ef5beb6212ffa49bc81b8c61c9724aa913c4b Mon Sep 17 00:00:00 2001 From: Arvind Kandpal <arvind.kandpal@ksolves.com> Date: Wed, 28 Oct 2026 13:38:26 +0530 Subject: [PATCH v2] doc: Mention that * does not include system columns Update the SELECT reference page to say that * and table_name.* in the output list do not include system columns, which must be listed by name, and link to the System Columns section. Discussion: https://postgr.es/m/178782026936.2606573.10270614257871556098@wrigleys.postgresql.org --- doc/src/sgml/ref/select.sgml | 3 +++ 1 file changed, 3 insertions(+) diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 18392f7caec..d1964463da6 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1158,6 +1158,9 @@ EXCLUDE NO OTHERS shorthand for the columns coming from just that table. In these cases it is not possible to specify new names with <literal>AS</literal>; the output column names will be the same as the table columns' names. + Neither form includes system columns; they must be listed by name, + as in <literal>SELECT ctid, * FROM t</literal>. (See <xref + linkend="ddl-system-columns"/>.) </para> <para> -- 2.43.0
^ permalink raw reply [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
@ 2026-11-02 07:54       ` Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-03 03:35         ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Arvind Kandpal @ 2026-11-02 07:54 UTC (permalink / raw)
  To: peter@eisentraut.org; +Cc: pgsql-docs@lists.postgresql.org

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.kandpal@ksolves.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@eisentraut.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]

Attachments:

v2-0001-doc-Mention-that-does-not-include-system-columns.patch (text/x-patch, 1.2K) download From 854ef5beb6212ffa49bc81b8c61c9724aa913c4b Mon Sep 17 00:00:00 2001 From: Arvind Kandpal <arvind.kandpal@ksolves.com> Date: Wed, 28 Oct 2026 13:38:26 +0530 Subject: [PATCH v2] doc: Mention that * does not include system columns Update the SELECT reference page to say that * and table_name.* in the output list do not include system columns, which must be listed by name, and link to the System Columns section. Discussion: https://postgr.es/m/178782026936.2606573.10270614257871556098@wrigleys.postgresql.org --- doc/src/sgml/ref/select.sgml | 3 +++ 1 file changed, 3 insertions(+) diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 18392f7caec..d1964463da6 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1158,6 +1158,9 @@ EXCLUDE NO OTHERS shorthand for the columns coming from just that table. In these cases it is not possible to specify new names with <literal>AS</literal>; the output column names will be the same as the table columns' names. + Neither form includes system columns; they must be listed by name, + as in <literal>SELECT ctid, * FROM t</literal>. (See <xref + linkend="ddl-system-columns"/>.) </para> <para> -- 2.43.0
^ permalink raw reply [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-02 07:54       ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
@ 2026-11-03 03:35         ` Matemática A3K <matematica.a3k@gmail.com>
  2026-11-03 07:37           ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Matemática A3K @ 2026-11-03 03:35 UTC (permalink / raw)
  To: Arvind Kandpal <arvind.kandpal@ksolves.com>; +Cc: peter@eisentraut.org; pgsql-docs@lists.postgresql.org

I think if you want to go in that direction, you should refactor saying
something like "* is the shorthand for all the user-defined columns (see
system columns)". What do you think?

On Mon, Nov 2, 2026 at 4:55 AM Arvind Kandpal <arvind.kandpal@ksolves.com>
wrote:

> 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.kandpal@ksolves.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@eisentraut.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]
>
>
>

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-02 07:54       ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-03 03:35         ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
@ 2026-11-03 07:37           ` Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-04 14:48             ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Arvind Kandpal @ 2026-11-03 07:37 UTC (permalink / raw)
  To: Matemática A3K <matematica.a3k@gmail.com>; +Cc: peter@eisentraut.org; pgsql-docs@lists.postgresql.org

> I think if you want to go in that direction, you should refactor saying
> something like "* is the shorthand for all the user-defined columns (see
> system columns)". What do you think?

Thanks for the suggestion. Changing the existing sentence is cleaner
than adding a new one.

The attached v3 changes the first sentence of that paragraph on the
SELECT reference page to say that * is a shorthand for all the columns
of the selected rows, not including system columns, with a link to the
System Columns section. I used "not including system columns" instead
of "user-defined columns", since the docs don't use that term for this.
I also dropped the example to keep the change small.

The docs build cleanly with make check and make html.

Thanks & Regards


On Tue, Nov 3, 2026 at 9:06 AM Matemática A3K <matematica.a3k@gmail.com> wrote:
>
> I think if you want to go in that direction, you should refactor saying something like "* is the shorthand for all the user-defined columns (see system columns)". What do you think?
>
> On Mon, Nov 2, 2026 at 4:55 AM Arvind Kandpal <arvind.kandpal@ksolves.com> wrote:
>>
>> 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.kandpal@ksolves.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@eisentraut.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 www.ksolves.com
>>>
>>> Years of
>>> listing on
>>
>>
>>
>> --
>> Arvind Kandpal
>> Junior Software Engineer
>> (+91) 9650266413 www.ksolves.com
>>
>> Years of
>> listing on
>>
>>



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

Years of
listing on

Attachments:

v3-0001-doc-Mention-that-does-not-include-system-columns.patch (text/x-patch, 1.3K) download From e3838bb8a10f45ba7ff12af495317620d2a555ae Mon Sep 17 00:00:00 2001 From: Arvind Kandpal <arvind.kandpal@ksolves.com> Date: Tue, 3 Nov 2026 11:19:42 +0530 Subject: [PATCH v3] doc: Mention that * does not include system columns In the SELECT reference page, say in the description of * in the output list that it does not include system columns, and link to the System Columns section. Discussion: https://postgr.es/m/178782026936.2606573.10270614257871556098@wrigleys.postgresql.org --- doc/src/sgml/ref/select.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 18392f7caec..9f3580ce49c 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1153,7 +1153,8 @@ EXCLUDE NO OTHERS <para> Instead of an expression, <literal>*</literal> can be written in the output list as a shorthand for all the columns of the selected - rows. Also, you can write <literal><replaceable + rows, not including system columns (see <xref + linkend="ddl-system-columns"/>). Also, you can write <literal><replaceable class="parameter">table_name</replaceable>.*</literal> as a shorthand for the columns coming from just that table. In these cases it is not possible to specify new names with <literal>AS</literal>; -- 2.43.0
^ permalink raw reply [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-02 07:54       ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-03 03:35         ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  2026-11-03 07:37           ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
@ 2026-11-04 14:48             ` Matemática A3K <matematica.a3k@gmail.com>
  2026-11-05 07:31               ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Matemática A3K @ 2026-11-04 14:48 UTC (permalink / raw)
  To: Arvind Kandpal <arvind.kandpal@ksolves.com>; +Cc: peter@eisentraut.org; pgsql-docs@lists.postgresql.org

On Tue, Nov 3, 2026 at 4:37 AM Arvind Kandpal
<arvind.kandpal@ksolves.com> wrote:
>
> > I think if you want to go in that direction, you should refactor saying
> > something like "* is the shorthand for all the user-defined columns (see
> > system columns)". What do you think?
>
> Thanks for the suggestion. Changing the existing sentence is cleaner
> than adding a new one.
>
> The attached v3 changes the first sentence of that paragraph on the
> SELECT reference page to say that * is a shorthand for all the columns
> of the selected rows, not including system columns, with a link to the
> System Columns section. I used "not including system columns" instead
> of "user-defined columns", since the docs don't use that term for this.
> I also dropped the example to keep the change small.

Hey Arvind, it LGTM with a small change: "* is a shorthand for all the
columns of the selected rows (not including <xref
linkend="ddl-system-columns" endterm="system columns"/>)." What do you
think?






^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-02 07:54       ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-03 03:35         ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  2026-11-03 07:37           ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-04 14:48             ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
@ 2026-11-05 07:31               ` Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-07 00:30                 ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Arvind Kandpal @ 2026-11-05 07:31 UTC (permalink / raw)
  To: Matemática A3K <matematica.a3k@gmail.com>; +Cc: peter@eisentraut.org; pgsql-docs@lists.postgresql.org

> Hey Arvind, it LGTM with a small change: "* is a shorthand for all the
> columns of the selected rows (not including <xref
> linkend="ddl-system-columns" endterm="system columns"/>)." What do you
> think?

Thanks for the review. I like that wording better.

endterm needs the id of an element, not free text, so this form fails
the doc check. I used <link linkend="ddl-system-columns">system
columns</link> instead, which gives the same rendered text, with
"system columns" as the link.

The attached v4 has this change. The docs build cleanly with make
check and make html.

I have also added the patch to the commitfest:
https://commitfest.postgresql.org/patch/7599/

Thanks,
Arvind Kandpal


On Wed, Nov 4, 2026 at 8:18 PM Matemática A3K <matematica.a3k@gmail.com> wrote:
>
> On Tue, Nov 3, 2026 at 4:37 AM Arvind Kandpal
> <arvind.kandpal@ksolves.com> wrote:
> >
> > > I think if you want to go in that direction, you should refactor saying
> > > something like "* is the shorthand for all the user-defined columns (see
> > > system columns)". What do you think?
> >
> > Thanks for the suggestion. Changing the existing sentence is cleaner
> > than adding a new one.
> >
> > The attached v3 changes the first sentence of that paragraph on the
> > SELECT reference page to say that * is a shorthand for all the columns
> > of the selected rows, not including system columns, with a link to the
> > System Columns section. I used "not including system columns" instead
> > of "user-defined columns", since the docs don't use that term for this.
> > I also dropped the example to keep the change small.
>
> Hey Arvind, it LGTM with a small change: "* is a shorthand for all the
> columns of the selected rows (not including <xref
> linkend="ddl-system-columns" endterm="system columns"/>)." What do you
> think?



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

Years of
listing on

Attachments:

v4-0001-doc-Mention-that-does-not-include-system-columns.patch (text/x-patch, 1.3K) download From 9b073c28627635a3aecb0cf5089d253daf28e75b Mon Sep 17 00:00:00 2001 From: Arvind Kandpal <arvind.kandpal@ksolves.com> Date: Thu, 5 Nov 2026 12:51:09 +0530 Subject: [PATCH v4] doc: Mention that * does not include system columns In the SELECT reference page, say in the description of * in the output list that it does not include system columns, with a link to the System Columns section. Discussion: https://postgr.es/m/178782026936.2606573.10270614257871556098@wrigleys.postgresql.org --- doc/src/sgml/ref/select.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 18392f7caec..f58d0031da2 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1153,7 +1153,8 @@ EXCLUDE NO OTHERS <para> Instead of an expression, <literal>*</literal> can be written in the output list as a shorthand for all the columns of the selected - rows. Also, you can write <literal><replaceable + rows (not including <link linkend="ddl-system-columns">system + columns</link>). Also, you can write <literal><replaceable class="parameter">table_name</replaceable>.*</literal> as a shorthand for the columns coming from just that table. In these cases it is not possible to specify new names with <literal>AS</literal>; -- 2.43.0
^ permalink raw reply [nested|flat] 10+ messages in thread

* Re: 4.1.4. Special Characters
  2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
  2026-10-28 08:15 ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-10-28 10:02   ` Re: 4.1.4. Special Characters Peter Eisentraut <peter@eisentraut.org>
  2026-10-28 10:13     ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-02 07:54       ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-03 03:35         ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  2026-11-03 07:37           ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
  2026-11-04 14:48             ` Re: 4.1.4. Special Characters Matemática A3K <matematica.a3k@gmail.com>
  2026-11-05 07:31               ` Re: 4.1.4. Special Characters Arvind Kandpal <arvind.kandpal@ksolves.com>
@ 2026-11-07 00:30                 ` Matemática A3K <matematica.a3k@gmail.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Matemática A3K @ 2026-11-07 00:30 UTC (permalink / raw)
  To: Arvind Kandpal <arvind.kandpal@ksolves.com>; +Cc: peter@eisentraut.org; pgsql-docs@lists.postgresql.org

It's a useful clarification to me. +1






^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2026-11-07 00:30 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-08-27 08:44 4.1.4. Special Characters PG Doc comments form <noreply@postgresql.org>
2026-10-28 08:15 ` Arvind Kandpal <arvind.kandpal@ksolves.com>
2026-10-28 10:02   ` Peter Eisentraut <peter@eisentraut.org>
2026-10-28 10:13     ` Arvind Kandpal <arvind.kandpal@ksolves.com>
2026-11-02 07:54       ` Arvind Kandpal <arvind.kandpal@ksolves.com>
2026-11-03 03:35         ` Matemática A3K <matematica.a3k@gmail.com>
2026-11-03 07:37           ` Arvind Kandpal <arvind.kandpal@ksolves.com>
2026-11-04 14:48             ` Matemática A3K <matematica.a3k@gmail.com>
2026-11-05 07:31               ` Arvind Kandpal <arvind.kandpal@ksolves.com>
2026-11-07 00:30                 ` Matemática A3K <matematica.a3k@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox