Dominique Devienne <ddevie...@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
