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 1kmfwA-0004xz-QU for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Dec 2020 16:34:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmfw9-0005lJ-PA for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Dec 2020 16:34:01 +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 1kmfw9-0005lB-IO for pgsql-hackers@lists.postgresql.org; Tue, 08 Dec 2020 16:34:01 +0000 Received: from relay9-d.mail.gandi.net ([217.70.183.199]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kmfw7-0000Og-AT for pgsql-hackers@postgresql.org; Tue, 08 Dec 2020 16:34:00 +0000 X-Originating-IP: 79.88.149.14 Received: from [172.16.255.146] (14.149.88.79.rev.sfr.net [79.88.149.14]) (Authenticated sender: vik@postgresfriends.org) by relay9-d.mail.gandi.net (Postfix) with ESMTPSA id 37576FF807; Tue, 8 Dec 2020 16:33:55 +0000 (UTC) Subject: Re: SEARCH and CYCLE clauses To: Peter Eisentraut , pgsql-hackers References: <54e533c5-09e5-7f41-9892-d4e0f7c62598@postgresfriends.org> <1cfc9079-9595-d167-00e6-5014438cc3e2@2ndquadrant.com> <9ce4d370-048c-1d67-fffb-a86f17120132@postgresfriends.org> <1a7fbf28-7bca-501e-3cbb-04e6776e1716@2ndquadrant.com> From: Vik Fearing Message-ID: <92d48260-453d-bd90-9048-6bd941eff5d0@postgresfriends.org> Date: Tue, 8 Dec 2020 17:33:55 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <1a7fbf28-7bca-501e-3cbb-04e6776e1716@2ndquadrant.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 6/15/20 11:49 AM, Peter Eisentraut wrote: > To fix the star expansion I had to add a little bit of infrastructure > that could also be used as a more general facility "don't include this > column in star expansion", so this could perhaps use some consideration > from a more general angle as well. Could this work be salvaged to add the ability to ALTER a column to hide it from star expansion? That's a feature I've often seen requested, especially from people working with PostGIS's geometry. Totally off-topic for this thread, though. -- Vik Fearing