Dominique Devienne <ddevienne@xxxxxxxxx> 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
