Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dsJfT-0006vF-88 for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Sep 2017 02:14:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dsJfS-0006Xw-Ja for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Sep 2017 02:14:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dsJfQ-0006Xj-UA for pgsql-hackers@postgresql.org; Thu, 14 Sep 2017 02:14:12 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dsJf9-000284-8w for pgsql-hackers@postgresql.org; Thu, 14 Sep 2017 02:14:12 +0000 Received: by fetter.org (Postfix, from userid 1001) id A0F9A401AD; Thu, 14 Sep 2017 04:13:53 +0200 (CEST) Date: Thu, 14 Sep 2017 04:13:53 +0200 From: David Fetter To: Andreas Karlsson Cc: Simon Riggs , Peter Eisentraut , pgsql-hackers Subject: Re: generated columns Message-ID: <20170914021353.GT10516@fetter.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On Wed, Sep 13, 2017 at 10:09:37AM +0200, Andreas Karlsson wrote: > On 09/13/2017 04:04 AM, Simon Riggs wrote: > >On 31 August 2017 at 05:16, Peter Eisentraut > > wrote: > >>- index support (and related constraint support) > > > >Presumably you can't index a VIRTUAL column. Or at least I don't > >think its worth spending time trying to make it work. > > I think end users would be surprised if one can index STORED columns > and expressions but not VIRTUAL columns. So unless it is a huge > project I would say it is worth it. So long as the expression on the normal columns was immutable, it's fit for an expressional index, as is any immutable function composed with it. What am I missing? Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers