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-000225-BJ 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-0004Wq-4W for pgsql-committers@arkaria.postgresql.org; Sat, 21 May 2022 18:47:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsU7K-0001OK-NW for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:22 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsU7E-0007lu-4e for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:21 +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-0002A6-AI 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 1nsU7B-000Tlx-VK for pgsql-committers@lists.postgresql.org; Sat, 21 May 2022 18:46:14 +0000 Content-Type: multipart/mixed; boundary="===============6108745812920001956==" 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 --===============6108745812920001956== 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 ODYtMWFkNmZkNzg2NzI4YjhhZkBwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm L2M3NDYxZmMyNTU1ODgzMmRkMzQ3YTljODE1MGIwZjFlZDg1ZTM2ZTgKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICAgfCAx MDcgKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL21hdHZpZXcub3V0IHwgICA0ICstCjIgZmlsZXMgY2hhbmdlZCwgNzAgaW5zZXJ0aW9u cygrKSwgNDEgZGVsZXRpb25zKC0pCgo= --===============6108745812920001956==--