Re: 7.2.1. The FROM Clause

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: jochen.bandhauer@gmx.net, pgsql-docs@lists.postgresql.org
Date: 2026-06-15T06:39:05Z
Lists: pgsql-docs

Attachments

On Sun, 2026-06-14 at 16:40 -0400, Tom Lane wrote:
> Laurenz Albe <laurenz.albe@cybertec.at> writes:
> > To be honest, I only learned about the syntax
> > "tab *" a few days ago.  Digging through the history, this syntax has been
> > obsolete since 2000.  I think we could remove both the paragraph that confuses
> > you and the asterisk from the syntax diagram.
> 
> I think we've discussed that before, and concluded that removing the
> docs would be a disservice to users who are trying to read old code
> that does this and don't know what it means.  Maybe that argument
> is too weak now to justify keeping the docs, but I'm unsure.
> I'd be inclined to just rephrase this sentence in hopes of making
> it less ambiguous.

Fine by me; here is a patch.

I could not resist the temptation to remove the "now always" in
"searching descendant tables is now always the default".  That sounds
too much like this was a recent change.

Yours,
Laurenz Albe

Commits

  1. Doc: reword discussion of asterisk after table names in FROM.