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 1k9IEy-0000EC-Sl for pgsql-docs@arkaria.postgresql.org; Sat, 22 Aug 2020 01:22:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k9IEx-0008QN-RX for pgsql-docs@arkaria.postgresql.org; Sat, 22 Aug 2020 01:22:39 +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 1k9IEx-0008QG-K8 for pgsql-docs@lists.postgresql.org; Sat, 22 Aug 2020 01:22:39 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k9IEr-0003FS-31 for pgsql-docs@lists.postgresql.org; Sat, 22 Aug 2020 01:22:38 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 07M1MVvA2099093; Fri, 21 Aug 2020 21:22:31 -0400 From: Tom Lane To: Bruce Momjian cc: sean@materialize.io, pgsql-docs@lists.postgresql.org Subject: Re: Subscript expressions do not have to evaluate to integers In-reply-to: <20200822003331.GN13363@momjian.us> References: <159538675800.624.7728794628229799531@wrigleys.postgresql.org> <20200822003331.GN13363@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Fri, 21 Aug 2020 20:33:31 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2099091.1598059351.1@sss.pgh.pa.us> Date: Fri, 21 Aug 2020 21:22:31 -0400 Message-ID: <2099092.1598059351@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Bruce Momjian writes: > On Wed, Jul 22, 2020 at 02:59:18AM +0000, PG Doc comments form wrote: >> I believe a more appropriate statement would acknowledge that at least some >> values undergo an explicit-style conversion to an integer. > OK, how is the attached patch? "and" is not an improvement over "which". Otherwise seems OK. (The proposed patch for generic subscripting will probably need to rewrite this completely, but for now this is an improvement.) regards, tom lane