Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZ0yV-000hhd-1e for pgsql-docs@arkaria.postgresql.org; Mon, 15 Jun 2026 06:39:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZ0yU-00AJWN-11 for pgsql-docs@arkaria.postgresql.org; Mon, 15 Jun 2026 06:39:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZ0yU-00AJWF-0E for pgsql-docs@lists.postgresql.org; Mon, 15 Jun 2026 06:39:10 +0000 Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wZ0yS-00000000R3U-1MXb for pgsql-docs@lists.postgresql.org; Mon, 15 Jun 2026 06:39:08 +0000 Received: by mail-wm1-x32f.google.com with SMTP id 5b1f17b1804b1-490b64c8311so30103205e9.3 for ; Sun, 14 Jun 2026 23:39:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1781505546; x=1782110346; darn=lists.postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=oblKYOgBXOGHvMvZkCivRWu2lsDE+MoXdrMW6M+M4/U=; b=aSHeOkERuWb/uS4ZpuAGD/yH4v84rICnOf074ZMh5F4ECXQhoDjDCtW9EZrTOxJtcJ OKrzGuBt55wGJ00HLL4c17q2k5yZKB0IJst5rmjs88ePeFOU6k8vCPgGIHlC0j1Dmaj8 iXrWeUIODPBc7+z+MfkT/m1gPXEpvkridH2BbCPxq5ptk5oka0axUCiv6+aVJp1er7nS 3RGu1b4wFNhmWRWRyAF6gnT8WG8oBLhTVPW7aow/tI0maqv2OmrggrYoPTdwzwq6X2/V +dnA6jS4tvwigo/jH3XVPaa18UgFThp0rnyHTSkeiLKGP/wWsRyUeRJ3u906pgJ0kDMR m8MA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781505546; x=1782110346; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=oblKYOgBXOGHvMvZkCivRWu2lsDE+MoXdrMW6M+M4/U=; b=mo/cl2YTPbg2WNsLdysWY7d1bjkS8WCMiCANWBWY5F8nhm4tIxo4Mua9LuIUC6tjZZ fbHPQcQmnbS94MeRnVP4gT7nuZhfa6W8rk4Vv6AkEbOGzVLwF7AEVEuQpfD1JW/Ow88l J0qWs/TQG4NvpOtBtJWksTIteZ4kPlothdM8VbSgiCqaaXN1xOeJIBGiJqBtRrm5nd53 oMuobZ4u/ThjMl81Ee0D7gOQfiQ2I8KKELQQ+ksS1VK+E5rFy1LwUkdcSLoL2NVDY2si H36vmKWfJwy3vs6KcHm6MvhxA2L9bNZfti9Sh6w752JVJDwt4wGrkSP1TBfJB2RqIC00 0Zbg== X-Forwarded-Encrypted: i=1; AFNElJ/4yg59pgGEg2T67fL3k0hoxdTRjbgpH0Oz7tOqZWggpViEjPrXV2XJfZcylZJ5BO272ATRB4IX3xgk@lists.postgresql.org X-Gm-Message-State: AOJu0YzSGdQs4PFgkChQ5mHFLeGcgDoycLkCm1XupgCu+u1g7B8CL++X dDvdUadivkfLlYY5HO/8KiZ5nrFJmCkH64g12YEguFdbr1ZPTnjWJsRdK/4C7JZfNX0= X-Gm-Gg: Acq92OFcDuf5kqyQB6h541yNqk6RB0YLMlELmkhZ1OgIDVGWYVmtIIFq8saaouL8w03 uRoe3sTuqKBiMyilJ/ejCYIZvdbLQmqHonmdYBq+y+amc5toKi/48R84Fn6qRBbcfzSw8SyROh/ JE71eeC8DJplgv0nZG1Su/8Vq/90Kh/EccQ+oYyJGDWt8uNjrb9TKh8U8h3J/U3hG8aaDJpC7l5 Ol4SBgwUqEIm0l0zQcpRRVY68KkHGvwt4GnggdyhC73rPT0vJ8eBSpinml5r/n0RepygGUE0dsL vS4fiXR+M/v8PMbtXwS06/ps2zm8gDbi+CNQx0Poo8fbS4PIcMnHmzyLfC9jdjjgQyOxGzuUtYm aEWbPeCCDk+2FzxU6lj65ofAWxSqhNAcU56tdGiKU8+4w63XwwbJIE9A8ih2wri8816CQ6x+JMV pORCL/qaVk5WGlNB3ksQ8uHPUDlOmyfdYcpIL3oDrwRQnyytt+GB4I0w== X-Received: by 2002:a05:600c:3b16:b0:491:e3be:1363 with SMTP id 5b1f17b1804b1-491e3be13b3mr152650155e9.0.1781505546385; Sun, 14 Jun 2026 23:39:06 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:21f:fc97:3ffd:7f89:d662]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4922031b7d2sm240778005e9.5.2026.06.14.23.39.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 14 Jun 2026 23:39:06 -0700 (PDT) Message-ID: Subject: Re: 7.2.1. The FROM Clause From: Laurenz Albe To: Tom Lane Cc: jochen.bandhauer@gmx.net, pgsql-docs@lists.postgresql.org Date: Mon, 15 Jun 2026 08:39:05 +0200 In-Reply-To: <118332.1781469634@sss.pgh.pa.us> References: <178125831604.1285960.8250607197280951685@wrigleys.postgresql.org> <36df7ebde5717e34d88228266c8aef21dc6e8c75.camel@cybertec.at> <118332.1781469634@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="=-yByI+hVlatRoWMjLARsd" User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-yByI+hVlatRoWMjLARsd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, 2026-06-14 at 16:40 -0400, Tom Lane wrote: > Laurenz Albe writes: > > To be honest, I only learned about the syntax > > "tab *" a few days ago. Digging through the history, this syntax has b= een > > obsolete since 2000. I think we could remove both the paragraph that c= onfuses > > you and the asterisk from the syntax diagram. >=20 > 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 --=-yByI+hVlatRoWMjLARsd Content-Disposition: attachment; filename="v1-0001-Reword-doc-for-asterisk-after-table-names.patch" Content-Type: text/x-patch; name="v1-0001-Reword-doc-for-asterisk-after-table-names.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSAyYTNjZmIzMmM3ZjNmZDYyNjYxN2QwNzViYTRmMGYzZTI4MThiNGU0IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogTW9uLCAxNSBKdW4gMjAyNiAwODozNDoyNyArMDIwMApTdWJqZWN0OiBbUEFUQ0gg djFdIFJld29yZCBkb2MgZm9yIGFzdGVyaXNrIGFmdGVyIHRhYmxlIG5hbWVzCgpUaGUgc3ludGF4 ICJ0YWJsZW5hbWUgKiIgaGFzIGJlZW4gb2Jzb2xldGUgc2luY2UgNy4xLCBidXQgd2Ugd2FudAp0 byByZXRhaW4gaXQgYW5kIGl0cyBkb2N1bWVudGF0aW9uIGZvciBiYWNrd2FyZCBjb21wYXRpYmls aXR5CnJlYXNvbnMuICBIb3dldmVyLCB0aGUgd29yZGluZyB3YXMgY29uZnVzaW5nIGFuZCBjb3Vs ZCBiZSB1bmRlcnN0b29kCnRvIG1lYW4gdGhhdCAidGFibGVuYW1lICoiIGlzIHRoZSBzYW1lIGFz ICJPTkxZIHRhYmxlbmFtZSIuCgpSZXBvcnRlZC1ieTogSm9jaGVuIEJhbmRoYXVlciA8am9jaGVu LmJhbmRoYXVlckBnbXgubmV0PgpBdXRob3I6IExhdXJlbnogQWxiZSA8bGF1cmVuei5hbGJlQGN5 YmVydGVjLmF0PgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE3ODEyNTgzMTYwNC4x Mjg1OTYwLjgyNTA2MDcxOTcyODA5NTE2ODUlNDB3cmlnbGV5cy5wb3N0Z3Jlc3FsLm9yZwotLS0K IGRvYy9zcmMvc2dtbC9xdWVyaWVzLnNnbWwgfCA4ICsrKystLS0tCiAxIGZpbGUgY2hhbmdlZCwg NCBpbnNlcnRpb25zKCspLCA0IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dt bC9xdWVyaWVzLnNnbWwgYi9kb2Mvc3JjL3NnbWwvcXVlcmllcy5zZ21sCmluZGV4IGVjNGNhMDFj ZDE2Li4zMDk2Yjk4NmEwOSAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3F1ZXJpZXMuc2dtbAor KysgYi9kb2Mvc3JjL3NnbWwvcXVlcmllcy5zZ21sCkBAIC0xNDMsMTAgKzE0MywxMCBAQCBGUk9N IDxyZXBsYWNlYWJsZT50YWJsZV9yZWZlcmVuY2U8L3JlcGxhY2VhYmxlPiA8b3B0aW9uYWw+LCA8 cmVwbGFjZWFibGU+dGFibGVfcgogICAgPC9wYXJhPgogCiAgICA8cGFyYT4KLSAgICBJbnN0ZWFk IG9mIHdyaXRpbmcgPGxpdGVyYWw+T05MWTwvbGl0ZXJhbD4gYmVmb3JlIHRoZSB0YWJsZSBuYW1l LCB5b3UgY2FuIHdyaXRlCi0gICAgPGxpdGVyYWw+KjwvbGl0ZXJhbD4gYWZ0ZXIgdGhlIHRhYmxl IG5hbWUgdG8gZXhwbGljaXRseSBzcGVjaWZ5IHRoYXQgZGVzY2VuZGFudAotICAgIHRhYmxlcyBh cmUgaW5jbHVkZWQuICBUaGVyZSBpcyBubyByZWFsIHJlYXNvbiB0byB1c2UgdGhpcyBzeW50YXgg YW55IG1vcmUsCi0gICAgYmVjYXVzZSBzZWFyY2hpbmcgZGVzY2VuZGFudCB0YWJsZXMgaXMgbm93 IGFsd2F5cyB0aGUgZGVmYXVsdCBiZWhhdmlvci4KKyAgICBZb3UgY2FuIHdyaXRlIDxsaXRlcmFs Pio8L2xpdGVyYWw+IGFmdGVyIHRoZSB0YWJsZSBuYW1lIHRvIGV4cGxpY2l0bHkKKyAgICBzcGVj aWZ5IHRoYXQgZGVzY2VuZGFudCB0YWJsZXMgYXJlIGluY2x1ZGVkLCB3aGljaCBpcyB0aGUgb3Bw b3NpdGUgb2YKKyAgICA8bGl0ZXJhbD5PTkxZPC9saXRlcmFsPi4gIFRoZXJlIGlzIG5vIHJlYWwg cmVhc29uIHRvIHVzZSB0aGlzIHN5bnRheAorICAgIGFueSBtb3JlLCBiZWNhdXNlIHNlYXJjaGlu ZyBkZXNjZW5kYW50IHRhYmxlcyBpcyB0aGUgZGVmYXVsdCBiZWhhdmlvci4KICAgICBIb3dldmVy LCBpdCBpcyBzdXBwb3J0ZWQgZm9yIGNvbXBhdGliaWxpdHkgd2l0aCBvbGRlciByZWxlYXNlcy4K ICAgIDwvcGFyYT4KIAotLSAKMi41NC4wCgo= --=-yByI+hVlatRoWMjLARsd--