Net Virtual Mailing Lists wrote: > My question is regarding creating an index on a view, or perhaps > another way to accomplish this.
Views are just macro expansions of queries (in a manner of speaking). To make queries on views use indexes, you create the indexes on the underlying tables in the same way as if you had typed in the expanded view query yourself. (In your example, you'd just need the usual indexes on the primary keys.) If what you want is that the creation of an index on a view automatically materializes that view (don't other database systems do that?), then you will have to implement that manually in PostgreSQL, with triggers and a bunch of code. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
