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 1t0vD4-00Dos4-V8 for pgsql-docs@arkaria.postgresql.org; Wed, 16 Oct 2024 04:00: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 1t0vD1-00FFBT-PH for pgsql-docs@arkaria.postgresql.org; Wed, 16 Oct 2024 04:00:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0vD1-00FF8L-EW for pgsql-docs@lists.postgresql.org; Wed, 16 Oct 2024 04:00:27 +0000 Received: from mail-japanwestazolkn19011029.outbound.protection.outlook.com ([52.103.66.29] helo=OS0P286CU010.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0vCw-001I7t-Gv for pgsql-docs@postgresql.org; Wed, 16 Oct 2024 04:00:27 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Z8Dadgq04BmkJJlvloV6YyN7FwIC+PCxp57IlqsjOExRkvGkXGQlih5A9lDFKPtKElJynyHqF4J6rzQUMIIF2jsWDP8aSHffvEI9GXAhcSK9vf2kyQeYw6bW353/d+VMZaGHsXwXcY6sJ7WfBN4chMO4Fw4LrGjJ4ysrakvS8YYsVTOK/btCmlXQ7ORprqkhdvZjopymVWzrCSYevV1bYCsrhd67+zeesHLrS1dV6ELH3/6gZCoOIw3jh4y/Pp2R6OdehF2pN/zoCacjU8v1naQYtzq1wfEpDWpFDtDx85P6kROx+OyrVazHS0aTrF7BogMfrXj2wzais04aKMw5iw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=IiGC2iwwBcICOg0Zmer+DwmgW+JhOsiF7erb5F9KR48=; b=JSj4oxKOo2WlYm9SowortANTGBZtMnqyeTvvjARSLCwCh/nFz5voJLGvNLEGDXP03zypRGzW6N7RrBL2t/3lVv+hiYjBRN4kWKECCUGz4P0FMWrU0xffgMSRx/82AtODPiMK+UJts3DiKD9hZWDUZ6ChV1Bd8xOLglFTol6H64QBU2Co8VNH3SVpZChlNjgcuxxVLvDLXpZjYh2+qf3icqjz5SgBTurjqCvP1HknhTDmHWQhwNefhVIPQ2IUbJHII6+O2f+PLGwvjfGm72MbHeDpQceOiytLKOR/NOH5bZhA9GQtcXTu6nFiC0Bhp3I5B8UY7pw7QnaJUIHzFgHikA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=IiGC2iwwBcICOg0Zmer+DwmgW+JhOsiF7erb5F9KR48=; b=rFQ2m++4GPYhehEwnz0Or+yy6oXejxiQPFFEIwPjQIb8U5E+xySjXEAUi0/wY+MvslL1EBkfawhWPOC2P3y040xFANDn9dIcqLG6ysJPxMAkkOEGaNu8j9e6sG6r6yWL8MEeKwwUXxmoaLrVp6dwQ9UECgADGoFjpiCW81/OEHYPbDSAFuiQ0vdYIJixlTTkrG+u6PapGSx4kwI1Wp/Umv6wfIJBWQ8K+uVeZ+zD9ef4/RTd0seSfZBenBHHQb6mC2A+JkODGCGfF76ofjKIXgIJglFciMwAhSay4U6GO4HjrZaKgHTDapv3IAwOsWhnfmWvov9QiQ8HxbzNZQjbGA== Received: from OSZP286MB0872.JPNP286.PROD.OUTLOOK.COM (2603:1096:604:f6::11) by TYWP286MB3176.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:2d7::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8048.22; Wed, 16 Oct 2024 04:00:17 +0000 Received: from OSZP286MB0872.JPNP286.PROD.OUTLOOK.COM ([fe80::baff:f734:4a86:ea4e]) by OSZP286MB0872.JPNP286.PROD.OUTLOOK.COM ([fe80::baff:f734:4a86:ea4e%4]) with mapi id 15.20.8069.016; Wed, 16 Oct 2024 04:00:17 +0000 From: Steve Lau To: Tom Lane , "david.g.johnston@gmail.com" CC: "pgsql-docs@postgresql.org" Subject: Re: Index of expression over table row or column Thread-Topic: Index of expression over table row or column Thread-Index: AQHbH3iAILFuI77/xEyLlFanvEKfVLKItoAAgAAKUoA= Date: Wed, 16 Oct 2024 04:00:17 +0000 Message-ID: References: <964FED20-AC2E-47C5-86FB-95C356A68B81@outlook.com> <4169601.1729048988@sss.pgh.pa.us> In-Reply-To: <4169601.1729048988@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OSZP286MB0872:EE_|TYWP286MB3176:EE_ x-ms-office365-filtering-correlation-id: 8ef769ff-fd97-4b3f-07cf-08dced970bb7 x-microsoft-antispam: BCL:0;ARA:14566002|8060799006|15080799006|461199028|19110799003|8062599003|102099032|440099028|3412199025; x-microsoft-antispam-message-info: +33gmIGjILl8IlVK8YwgHVjiLApfkoZ3j2Bwr/QUBBXXsNEMrF22yGdrMoYDmolgC8a56h75kjKifjGRLYbT7eweAYQqrLM1Al9PKnEhizeodW3OjsQ/aIf6FyESePOmJbPc/pYZ+VvbR5Dd89h93gSM+z4ElMn1P6fpOiIGYl8OKgFwwHXVCNfh44h2zFm1Av2UwTDYEUGp4BBowGGe4y2nW9aVBTa/icqPJJK+Ky8nJ8t0OnJiC7anE3+5PUCRqPOFdCXlbZDmN0rgCY22Yy75Gl0vFMhXiV+o6Bqqgswt1LDe3EEWhJh5BAjtkdQeG3HqYzuILkIjDiB59jpm4cycpT8UwZpA78cu6pc91CEW1fCggfy+d5Dm1y+AOnFnJNrblgqLzpvl48vGlzpZ8KCI47FxIx1Q6zmOEgBo0pcV/0Fp+yFit3nVA3ygmv0ek2IyScHuWfiuKljRipwiUvn/7lelOIBb5EyHjlkwS1EqwdpeG4x/WnyP00YTx1gMbCXJul22cfRkxtKF2c9Oa6sIrEZoBEGrOtNDFBYYqX8DdILpYw7Hmb6iHkNVvs/0OxRSCX70vKMcOBAylfobSDFJuL+cvDn92nxoGf9jMRZW3aHqMLuDNovYmLB7cIYcvEeJCKT5Wxr/EObDi75sBrDJAuj6TswSPCg9URN0fLR3fdHPvg76JcDCuJE6HAciwRky/jJ7FOc0fOcWVISd+A== x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?U09YTDhITTZONklCNklyYVB4eDNGUHdUbTl6WUUrS0NZZUJpSkdBT254Y0Y2?= =?utf-8?B?alNmSnlKMGFSVFNqZGt6cThBUlN2WFlWeVhON0J5UnYrVENkYTB2VFYva1NK?= =?utf-8?B?dkVZQTNlWjZScWpmYmJEdHpxTGlzWXozVmdlN2l3MW10bjVkTUNSaldXUmRt?= =?utf-8?B?QjkrRjlkOFh1dFk4TkFmNk1qVnJTcG5GaGV0THdIOUtKM3pOVlRwb3BaWWpW?= =?utf-8?B?SS9qZjkwU0I1QzhLUUlQaThLSW9wbFdlUUloZjc4Q1E1bkhKZFZVN1hPdC9q?= =?utf-8?B?M1lrSis3eTZPblQrSUg3T0UvczhSZytYSUhGMG5wSW9zeklQVklMMXZVOGNF?= =?utf-8?B?cGY5SkgyWVNvcGhTZVZJWUtXRFQxUnEvblA0MTVQdklyZDRjN01wei83N0wy?= =?utf-8?B?TWF4bzgrdVA4aFBHQVhXQW9QYXBXbmZTVXgyZVhPUkVkdFRzbUVCM1huMzZI?= =?utf-8?B?Nlg4WnZER3FSbnp3dnNabEx5SExlcnZ3bUZtVEJtUVZUd1R3bnlxVDduY3pu?= =?utf-8?B?TUpVSHhQYVpGRkR3K1hXbkthZmdrVWRaOVcvMGRsRnNDS05EcmJWYy9NOTNh?= =?utf-8?B?LzcvWE9zOFhNM1NOeldDdzc3WHhndkZBK0c0RUx2WlRIbVZGemd5eUFoUHhm?= =?utf-8?B?S09Xa0R5dzNBaHhDcUZJYTh5T1pNbTRGb2NvQkFCTjRIdWZwZXA1YkpXSXZP?= =?utf-8?B?NC95bVhjaURUMVIycE1TYmlmUkNxRjNrV2UvZzl0N0FYQkdwS0lGTHBLZWor?= =?utf-8?B?dDd0TnVVUTJDTVp2U3Y3QXQ2MEkzZ05CaU04VC9nL21jNkl4Ylk5dEs3N3Bs?= =?utf-8?B?OEx4RWVVWk5WcWR1dDhPdHhobFM3Wmc3bU5TM1ljR2JWUEhxVkNvWi80T3B5?= =?utf-8?B?aDU5a0hiYlpCdGhFYnc0V3hjOVR1em5uajNXL1dnUEliRGdaTUJ2QnJjU09O?= =?utf-8?B?aUFEOHdOeGZTV1lZSWVCTHU2bHVqSlErd3FNWEVNeFBsdVBuSVJSWXpOWWJY?= =?utf-8?B?QzIySElOWVN6V3JWQUZzNkpFMnFYdGc4OWhaN0pwaWJ5dVBqVWMxYno0Y2hk?= =?utf-8?B?WS9HRk9zSXo0SkRJMWloUnBZUkFnb28wdGh6cmhBNUg0dktqdzNFNDcyZTZU?= =?utf-8?B?MDl2dlRiaXZqNUMzR3V2ZHdDQ1RtcVhqcGpZQVpBMldXeXhIV3h3bVlOWmNj?= =?utf-8?B?blpzVUFuYTR2b25jYzRUczhvTGJkYlBDbXNzQWRIcnlQNWlLd1YwTkczdU1w?= =?utf-8?B?NjF0WTY5aDN2ak9wT0tEckloOHptb1IwTVAvQ1FxdFlrVUhLT2kwQlprRWpL?= =?utf-8?B?VXVtRlNjdWRLS2I1cjlrNEN1YjdjcVVYQXB3RmVhcmFROWJGbEkyWkY0NGtB?= =?utf-8?B?ZnVTcGJ0RllZSDBDRDBZZXlmcE9keHVQZVpHYStwQW1Zanc3UVVxTnd6NElD?= =?utf-8?B?a0hFYVBaVjVKUTJEZWJQQXVFRnVuZmkzYzg3NEF5WXk5Vkc2bWZJamNFYTNY?= =?utf-8?B?anJPQTBkOXEyUDhRd2ZuMHRiakFKdUdua0tUUlhGSFJSdElvY1BNd2gvS1Q5?= =?utf-8?B?YmVOcXAza1REa2dDMkUrV2x0UHMrSjBFdktjbHAwMG9ub3BGS0lFWkx2Z3VO?= =?utf-8?Q?L9JFclr8ms8x+FnwzXC7Gav7MgC2aiCa2nyTEs78WKmQ=3D?= Content-Type: text/plain; charset="utf-8" Content-ID: <457A8564E882C0479B2A0AD60DCC1C7D@JPNP286.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OSZP286MB0872.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 8ef769ff-fd97-4b3f-07cf-08dced970bb7 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Oct 2024 04:00:17.1550 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWP286MB3176 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksIHRoYW5rcyBib3RoIGZvciB0aGUgcmVwbHkuDQoNCj4gVGhlIGRlc2NyaXB0aW9uIGZvciBw Z19pbmRleC5pbmRrZXkgdXNlcyB0aGUgcGhyYXNpbmcg4oCcYW4gZXhwcmVzc2lvbiBvdmVyIHRo ZSB0YWJsZSBjb2x1bW5z4oCdIGFuZCB0aGlzIHNob3VsZCBiZSBtYWRlIHRvIG1hdGNoLg0KDQpU aGFua3MgRGF2aWQgZm9yIHNob3dpbmcgbWUgdGhhdCBleGlzdGluZyBkb2N1bWVudGF0aW9uLCBJ IGFncmVlIHdlIHNob3VsZCBtYWtlIHRoZW0gbWF0Y2guDQoNClJlZ2FyZGluZyBUb23igJlzIHJl cGx5LCBJTUhPLCDigJxMT1dFUihsYXN0X25hbWUgfHwgJyAnIHx8IGZpcnN0X25hbWUp4oCdIGlz IHN0aWxsIGFuIGV4cHJlc3Npb24gb3ZlciB0YWJsZSBjb2x1bW5zPyBXb3VsZCB5b3UgbGlrZSB0 byBlbGFib3JhdGUgb24gaXQgYSBiaXQ/DQoNClJlZ2FyZHMsIFN0ZXZlLg==