Re: [HACKERS] generated columns - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: [HACKERS] generated columns
Date
Msg-id c0ebd1e1-7625-70c8-7cfd-f07c5529dff5@proxel.se
Whole thread Raw
In response to Re: [HACKERS] generated columns  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [HACKERS] generated columns  (Simon Riggs <simon@2ndquadrant.com>)
Re: [HACKERS] generated columns  (David Fetter <david@fetter.org>)
List pgsql-hackers
On 09/13/2017 04:04 AM, Simon Riggs wrote:
> On 31 August 2017 at 05:16, Peter Eisentraut
> <peter.eisentraut@2ndquadrant.com> 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.

Andreas


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Restricting maximum keep segments by repslots
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] psql: new help related to variables are not tooreadable