Re: 7.2.1. The FROM Clause

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: jochen.bandhauer@gmx.net, pgsql-docs@lists.postgresql.org
Date: 2026-06-15T17:14:28Z
Lists: pgsql-docs
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Mon, 2026-06-15 at 11:05 -0400, Tom Lane wrote:
>> I can look up the version where it changed, if this seems like the way
>> to go.

> I did, and * became obsolete with 7.1.  It's even in the release notes.

Well, not really.  7.1 changed this behavior to depend on the
sql_inheritance GUC.  It wasn't till v10 when we removed that GUC
(see e13486eba) that you could really safely assume that an
undecorated table name includes child tables.  So I think we should
say it's obsolete since v10 not 7.1.

Pushed with those changes.

			regards, tom lane



Commits

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