Re: generated columns

From: Andreas Karlsson <andreas(at)proxel(dot)se>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: generated columns
Date: 2017-09-13 08:09:37
Message-ID: c0ebd1e1-7625-70c8-7cfd-f07c5529dff5@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09/13/2017 04:04 AM, Simon Riggs wrote:
> On 31 August 2017 at 05:16, Peter Eisentraut
> <peter(dot)eisentraut(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2017-09-13 08:13:06 Re: psql: new help related to variables are not too readable
Previous Message Kyotaro HORIGUCHI 2017-09-13 08:08:16 Re: Restricting maximum keep segments by repslots