Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsU85-000224-9o for pgsql-committers@arkaria.postgresql.org; Sat, 21 May 2022 18:47:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nsU84-0004Wr-4b for pgsql-committers@arkaria.postgresql.org; Sat, 21 May 2022 18:47:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsU7L-0001mm-A1 for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:23 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsU7F-0002cC-AD for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:22 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsU7D-0002A9-AL for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nsU7C-000Tm4-12 for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:14 +0000 Content-Type: multipart/mixed; boundary="===============6538210921517600175==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Show 'AS "?column?"' explicitly when it's important. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 21 May 2022 18:46:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6538210921517600175== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2hvdyAnQVMgIj9jb2x1bW4/IicgZXhwbGljaXRseSB3aGVuIGl0J3MgaW1wb3J0YW50LgoKcnVs ZXV0aWxzLmMgd2FzIGNvZGVkIHRvIHN1cHByZXNzIHRoZSBBUyBsYWJlbCBmb3IgYSBTRUxFQ1Qg b3V0cHV0CmV4cHJlc3Npb24gaWYgdGhlIGNvbHVtbiBuYW1lIGlzICI/Y29sdW1uPyIsIHdoaWNo IGlzIHRoZSBwYXJzZXIncwpmYWxsYmFjayBpZiBpdCBjYW4ndCB0aGluayBvZiBzb21ldGhpbmcg YmV0dGVyLiAgVGhpcyBpcyBmaW5lLCBhbmQKYXZvaWRzIHVnbHkgY2x1dHRlciwgc28gbG9uZyBh cyAoMSkgbm90aGluZyBmdXJ0aGVyIHVwIGluIHRoZSBwYXJzZQp0cmVlIHJlbGllcyBvbiB0aGF0 IGNvbHVtbiBuYW1lIG9yICgyKSB0aGUgc2FtZSBmYWxsYmFjayB3b3VsZCBiZQphc3NpZ25lZCB3 aGVuIHRoZSBydWxlIG9yIHZpZXcgZGVmaW5pdGlvbiBpcyByZWxvYWRlZC4gIFVuZm9ydHVuYXRl bHkKKDIpIGlzIGZhciBmcm9tIGNlcnRhaW4sIGJvdGggYmVjYXVzZSBydWxldXRpbHMuYyBtaWdo dCBwcmludCB0aGUKZXhwcmVzc2lvbiBpbiBhIGRpZmZlcmVudCBmb3JtIGZyb20gaG93IGl0IHdh cyBvcmlnaW5hbGx5IHdyaXR0ZW4KYW5kIGJlY2F1c2UgRmlndXJlQ29sbmFtZSdzIHJ1bGVzIG1p Z2h0IGNoYW5nZSBpbiBmdXR1cmUgcmVsZWFzZXMuClNvIHdlIHNob3VsZG4ndCByZWx5IG9uIHRo YXQuCgpEZXRlY3RpbmcgZXhhY3RseSB3aGV0aGVyIHRoZXJlIGlzIGFueSBvdXRlci1sZXZlbCB1 c2Ugb2YgYSBTRUxFQ1QKY29sdW1uIG5hbWUgd291bGQgYmUgcmF0aGVyIGV4cGVuc2l2ZS4gIFRo aXMgcGF0Y2ggdGFrZXMgdGhlIHNpbXBsZXIKYXBwcm9hY2ggb2YganVzdCBwYXNzaW5nIGRvd24g YSBmbGFnIGluZGljYXRpbmcgd2hldGhlciB0aGVyZSAqY291bGQqCmJlIGFueSBvdXRlciB1c2U7 IGZvciBleGFtcGxlLCB0aGUgb3V0cHV0IGNvbHVtbiBuYW1lcyBvZiBhIFN1YkxpbmsKYXJlIG5v dCByZWZlcmVuY2VhYmxlLCBhbmQgd2UgYWxzbyBkbyBub3QgY2FyZSBhYm91dCB0aGUgbmFtZXMg ZXhwb3NlZApieSB0aGUgcmlnaHQtaGFuZCBzaWRlIG9mIGEgc2V0b3AuICBUaGlzIGlzIHN1ZmZp Y2llbnQgdG8gc3VwcHJlc3MKdW53YW50ZWQgY2x1dHRlciBpbiBhbGwgYnV0IG9uZSBjYXNlIGlu IHRoZSByZWdyZXNzaW9uIHRlc3RzLiAgVGhhdApzZWVtcyBsaWtlIHJlYXNvbmFibGUgZXZpZGVu Y2UgdGhhdCBpdCB3b24ndCBiZSB0b28gbXVjaCBpbiB1c2VycycKZmFjZXMsIHdoaWxlIHN0aWxs IGZpeGluZyB0aGUgY2FzZXMgd2UgbmVlZCB0byBmaXguCgpQZXIgYnVnICMxNzQ4NiBmcm9tIE5p Y29sYXMgTHV0aWMuICBUaGlzIGlzc3VlIGlzIGFuY2llbnQsIHNvCmJhY2stcGF0Y2ggdG8gYWxs IHN1cHBvcnRlZCBicmFuY2hlcy4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTc0 ODYtMWFkNmZkNzg2NzI4YjhhZkBwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQpSRUxfMTJf U1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29t bWl0ZGlmZi9iYjJjMDQ2NzZiZTBlZmU4N2VhZmE3MzQyZGMxMTQzY2I5ZmIyZDIwCgpNb2RpZmll ZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMg ICAgIHwgMTAwICsrKysrKysrKysrKysrKysrKysrKystLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9tYXR2aWV3Lm91dCB8ICAgNCArLQoyIGZpbGVzIGNoYW5nZWQsIDY2IGlu c2VydGlvbnMoKyksIDM4IGRlbGV0aW9ucygtKQoK --===============6538210921517600175==--