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.94.2) (envelope-from ) id 1rk1Qk-009iOL-C3 for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Mar 2024 12:40:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rk1Qi-00Bv3F-OR for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Mar 2024 12:40:29 +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.94.2) (envelope-from ) id 1rk1Qh-00Bv36-RK for pgsql-hackers@lists.postgresql.org; Tue, 12 Mar 2024 12:40:28 +0000 Received: from m15.mail.126.com ([45.254.50.223]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rk1Qc-0047Mu-1C for pgsql-hackers@lists.postgresql.org; Tue, 12 Mar 2024 12:40:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=pG7VMzddzgZnYTW6uvGnwqCqkX0zA23QAB4DJEPv/rg=; b=P hMMSADvc9ujEuhMLd71TnYt+aLQ3yrl00Kqjm7S6rwqEr8x0NvpoKYwgaJmD3akS lH892vBn1N8P6U9S+IzSLG/YJwFIp+kRUtWjMawNDJWliddTDLKeD8dv3mNuGzTx 0Nmn3o/IwD5Ldf4xoCFZ2mwa4viywJ/wanqQSkODOU= Received: from winterloo$126.com ( [101.71.9.239] ) by ajax-webmail-wmsvr-41-109 (Coremail) ; Tue, 12 Mar 2024 20:40:15 +0800 (CST) X-Originating-IP: [101.71.9.239] Date: Tue, 12 Mar 2024 20:40:15 +0800 (CST) From: "adjkldd@126.com" To: pgsql-hackers@lists.postgresql.org Subject: confusing `case when` column name X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2024 www.mailtech.cn 126com X-NTES-SC: AL_Qu2aAv6fuEoq4yCRYekXk04aj+g2X8e3v/wl2oJfOJs0pS7s9C0afnxYOUTk3v6fJjirsxuOSiBBy8VTQrhgeqWrZphUv6QqGhyQ9j8wPafo Content-Type: multipart/alternative; boundary="----=_Part_129385_2132882354.1710247215099" MIME-Version: 1.0 Message-ID: <336abc39.8084.18e32ad7ffc.Coremail.winterloo@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID:_____wD3P+kvTfBl3yQPAA--.11330W X-CM-SenderInfo: xzlq3vpuor0qqrswhudrp/1tbi5gOfxmVLY8+2lwAFsa X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_129385_2132882354.1710247215099 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 SGkgaGFja2VycywKCkJlbG93IGlzIGEgYGNhc2Ugd2hlbmAgZGVtbywKCmBgYHNxbApjcmVhdGUg dGFibGUgZm9vKGEgaW50LCBiIGludCk7Cmluc2VydCBpbnRvIGZvbyB2YWx1ZXMgKDEsIDIpOwpz ZWxlY3QgY2FzZSAxIHdoZW4gMSB0aGVuIGEgZWxzZSBiIGVuZCBmcm9tIGZvbzsKYGBgCgoKQ3Vy cmVudGx5LCBwc3FsIG91dHB1dCBpcywKCgpgYGB0ZXh0CiBiCi0tLQogMQooMSByb3cpCmBgYAoK CkF0IHRoZSBmaXJzdCBnbGFuY2UgYXQgdGhlIG91dHB1dCBjb2x1bW4gdGl0bGUsIEkgYXNzdW1l IHRoZSByZXN1bHQgb2YgdGhlIHNxbCBpcyB3cm9uZy4gSXQgc2hvdWxkIGJlIGBhYC4KQWZ0ZXIg c29tZSBpbnZlc3RpZ2F0aW9uLCBJIGRpc2NvdmVyZWQgdGhhdCB0aGUgcmVzdWx0J3MgdmFsdWUg aXMgYWNjdXJhdGUuIEhvd2V2ZXIsIFBvc3RncmVTUUwgdXRpbGl6ZXMgYiBhcyB0aGUgdGl0bGUg Zm9yIHRoZSBvdXRwdXQgY29sdW1uLgpOZWUgd2UgY2hhbmdlIHRoZSB0aXRsZSBvZiB0aGUgY2Fz ZS13aGVuIG91dHB1dCBjb2x1bW4/IElmIHlvdSBoYWNrZXJzIHRoaW5rIGl0J3Mgd29ydGggdGhl IGVmZm9ydCwgSSdtIHdpbGxpbmcgdG8gaW52ZXN0IHRpbWUgaW4gd29ya2luZyBvbiBpdC4KQmVz dCBSZWdhcmRzLApXaW50ZXIgTG9v ------=_Part_129385_2132882354.1710247215099 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwcmUgc3R5bGU9IndpZHRoOiAxNjAyLjY0cHg7IHdvcmQtYnJl YWs6IGJyZWFrLXdvcmQgIWltcG9ydGFudDsiPkhpIGhhY2tlcnMsCgo8ZGl2PkJlbG93IGlzIGEg YGNhc2Ugd2hlbmAgZGVtbyw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PmBgYHNxbDwvZGl2Pjxk aXY+Y3JlYXRlIHRhYmxlIGZvbyhhIGludCwgYiBpbnQpOzwvZGl2PjxkaXY+aW5zZXJ0IGludG8g Zm9vIHZhbHVlcyAoMSwgMik7PC9kaXY+PGRpdj5zZWxlY3QgY2FzZSAxIHdoZW4gMSB0aGVuIGEg ZWxzZSBiIGVuZCBmcm9tIGZvbzs8L2Rpdj48ZGl2PmBgYDwvZGl2PjxkaXY+PGJyPjwvZGl2Pjxk aXY+Q3VycmVudGx5LCBwc3FsIG91dHB1dCBpcyw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PmBg YHRleHQ8L2Rpdj48ZGl2PiBiCi0tLQogMQooMSByb3cpPC9kaXY+PGRpdj5gYGA8L2Rpdj48ZGl2 Pjxicj48L2Rpdj48ZGl2PkF0IHRoZSBmaXJzdCBnbGFuY2UgYXQgdGhlIG91dHB1dCBjb2x1bW4g dGl0bGUsIEkgYXNzdW1lIHRoZSByZXN1bHQgb2YgdGhlIHNxbCBpcyB3cm9uZy4gSXQgc2hvdWxk IGJlIGBhYC48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJjb2xvcjogcmdiKDEzLCAxMywgMTMpOyBm b250LWZhbWlseTogU8O2aG5lLCB1aS1zYW5zLXNlcmlmLCBzeXN0ZW0tdWksIC1hcHBsZS1zeXN0 ZW0sICZxdW90O1NlZ29lIFVJJnF1b3Q7LCBSb2JvdG8sIFVidW50dSwgQ2FudGFyZWxsLCAmcXVv dDtOb3RvIFNhbnMmcXVvdDssIHNhbnMtc2VyaWYsICZxdW90O0hlbHZldGljYSBOZXVlJnF1b3Q7 LCBBcmlhbCwgJnF1b3Q7QXBwbGUgQ29sb3IgRW1vamkmcXVvdDssICZxdW90O1NlZ29lIFVJIEVt b2ppJnF1b3Q7LCAmcXVvdDtTZWdvZSBVSSBTeW1ib2wmcXVvdDssICZxdW90O05vdG8gQ29sb3Ig RW1vamkmcXVvdDs7IGZvbnQtc2l6ZTogMTZweDsiPkFmdGVyIHNvbWUgaW52ZXN0aWdhdGlvbiwg SSBkaXNjb3ZlcmVkIHRoYXQgdGhlIHJlc3VsdCdzIHZhbHVlIGlzIGFjY3VyYXRlLiBIb3dldmVy LCBQb3N0Z3JlU1FMIHV0aWxpemVzIDwvc3Bhbj48Y29kZSBzdHlsZT0iYm9yZGVyOiAwcHggc29s aWQgcmdiKDIyNywgMjI3LCAyMjcpOyBib3gtc2l6aW5nOiBib3JkZXItYm94OyAtLXR3LWJvcmRl ci1zcGFjaW5nLXg6IDA7IC0tdHctYm9yZGVyLXNwYWNpbmcteTogMDsgLS10dy10cmFuc2xhdGUt eDogMDsgLS10dy10cmFuc2xhdGUteTogMDsgLS10dy1yb3RhdGU6IDA7IC0tdHctc2tldy14OiAw OyAtLXR3LXNrZXcteTogMDsgLS10dy1zY2FsZS14OiAxOyAtLXR3LXNjYWxlLXk6IDE7IC0tdHct cGFuLXg6IDsgLS10dy1wYW4teTogOyAtLXR3LXBpbmNoLXpvb206IDsgLS10dy1zY3JvbGwtc25h cC1zdHJpY3RuZXNzOiBwcm94aW1pdHk7IC0tdHctZ3JhZGllbnQtZnJvbS1wb3NpdGlvbjogOyAt LXR3LWdyYWRpZW50LXZpYS1wb3NpdGlvbjogOyAtLXR3LWdyYWRpZW50LXRvLXBvc2l0aW9uOiA7 IC0tdHctb3JkaW5hbDogOyAtLXR3LXNsYXNoZWQtemVybzogOyAtLXR3LW51bWVyaWMtZmlndXJl OiA7IC0tdHctbnVtZXJpYy1zcGFjaW5nOiA7IC0tdHctbnVtZXJpYy1mcmFjdGlvbjogOyAtLXR3 LXJpbmctaW5zZXQ6IDsgLS10dy1yaW5nLW9mZnNldC13aWR0aDogMHB4OyAtLXR3LXJpbmctb2Zm c2V0LWNvbG9yOiAjZmZmOyAtLXR3LXJpbmctY29sb3I6IHJnYmEoNjksODksMTY0LC41KTsgLS10 dy1yaW5nLW9mZnNldC1zaGFkb3c6IDAgMCB0cmFuc3BhcmVudDsgLS10dy1yaW5nLXNoYWRvdzog MCAwIHRyYW5zcGFyZW50OyAtLXR3LXNoYWRvdzogMCAwIHRyYW5zcGFyZW50OyAtLXR3LXNoYWRv dy1jb2xvcmVkOiAwIDAgdHJhbnNwYXJlbnQ7IC0tdHctYmx1cjogOyAtLXR3LWJyaWdodG5lc3M6 IDsgLS10dy1jb250cmFzdDogOyAtLXR3LWdyYXlzY2FsZTogOyAtLXR3LWh1ZS1yb3RhdGU6IDsg LS10dy1pbnZlcnQ6IDsgLS10dy1zYXR1cmF0ZTogOyAtLXR3LXNlcGlhOiA7IC0tdHctZHJvcC1z aGFkb3c6IDsgLS10dy1iYWNrZHJvcC1ibHVyOiA7IC0tdHctYmFja2Ryb3AtYnJpZ2h0bmVzczog OyAtLXR3LWJhY2tkcm9wLWNvbnRyYXN0OiA7IC0tdHctYmFja2Ryb3AtZ3JheXNjYWxlOiA7IC0t dHctYmFja2Ryb3AtaHVlLXJvdGF0ZTogOyAtLXR3LWJhY2tkcm9wLWludmVydDogOyAtLXR3LWJh Y2tkcm9wLW9wYWNpdHk6IDsgLS10dy1iYWNrZHJvcC1zYXR1cmF0ZTogOyAtLXR3LWJhY2tkcm9w LXNlcGlhOiA7IGZvbnQtc2l6ZTogMC44NzVlbTsgY29sb3I6IHJnYigxMywgMTMsIDEzKTsgZm9u dC13ZWlnaHQ6IDYwMDsgZm9udC1mYW1pbHk6ICZxdW90O1PDtmhuZSBNb25vJnF1b3Q7LCBNb25h Y28sICZxdW90O0FuZGFsZSBNb25vJnF1b3Q7LCAmcXVvdDtVYnVudHUgTW9ubyZxdW90OywgbW9u b3NwYWNlICFpbXBvcnRhbnQ7Ij5iPC9jb2RlPjxzcGFuIHN0eWxlPSJjb2xvcjogcmdiKDEzLCAx MywgMTMpOyBmb250LWZhbWlseTogU8O2aG5lLCB1aS1zYW5zLXNlcmlmLCBzeXN0ZW0tdWksIC1h cHBsZS1zeXN0ZW0sICZxdW90O1NlZ29lIFVJJnF1b3Q7LCBSb2JvdG8sIFVidW50dSwgQ2FudGFy ZWxsLCAmcXVvdDtOb3RvIFNhbnMmcXVvdDssIHNhbnMtc2VyaWYsICZxdW90O0hlbHZldGljYSBO ZXVlJnF1b3Q7LCBBcmlhbCwgJnF1b3Q7QXBwbGUgQ29sb3IgRW1vamkmcXVvdDssICZxdW90O1Nl Z29lIFVJIEVtb2ppJnF1b3Q7LCAmcXVvdDtTZWdvZSBVSSBTeW1ib2wmcXVvdDssICZxdW90O05v dG8gQ29sb3IgRW1vamkmcXVvdDs7IGZvbnQtc2l6ZTogMTZweDsiPiBhcyB0aGUgdGl0bGUgZm9y IHRoZSBvdXRwdXQgY29sdW1uLjwvc3Bhbj48L2Rpdj48ZGl2Pk5lZSB3ZSBjaGFuZ2UgdGhlIHRp dGxlIG9mIHRoZSBjYXNlLXdoZW4gb3V0cHV0IGNvbHVtbj8gSWYgeW91IGhhY2tlcnMgdGhpbmsg aXQncyB3b3J0aCB0aGUgZWZmb3J0LCBJJ20gd2lsbGluZyB0byBpbnZlc3QgdGltZSBpbiB3b3Jr aW5nIG9uIGl0LjwvZGl2Pgo8ZGl2PkJlc3QgUmVnYXJkcyw8L2Rpdj48ZGl2PldpbnRlciBMb288 L2Rpdj48L3ByZT48L2Rpdj4= ------=_Part_129385_2132882354.1710247215099--