Dominique Devienne <ddevienne(at)gmail(dot)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