Re: Non-Stored Generated Columns - Mailing list pgsql-general

From Tom Lane
Subject Re: Non-Stored Generated Columns
Date
Msg-id 2425903.1709147504@sss.pgh.pa.us
Whole thread Raw
In response to Re: Non-Stored Generated Columns  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Non-Stored Generated Columns  (Ron Johnson <ronljohnsonjr@gmail.com>)
Re: Non-Stored Generated Columns  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Dominique Devienne <ddevienne@gmail.com> writes:
> Views can have foreign-keys?

Surely you'd put the FK on the underlying table.

> Generated view columns be indexed?

You want an index on a virtual column?  Sure, just build an expression
index (on the underlying table) that matches it.

I agree with Laurenz that it's hard to see much use-case here
that's not sufficiently covered already.

            regards, tom lane



pgsql-general by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: Documentation diff
Next
From: Dimitrios Apostolou
Date:
Subject: Re: Orphan files filling root partition after crash