Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA29671; Tue, 19 May 92 09:05:49 -0700
Message-Id: <9205191605.AA29671@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: Indexing Views
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Thu, 14 May 92 09:35:19 +0700."
             <9205140730.AA22294@postgres.Berkeley.EDU> 
Date: Tue, 19 May 92 09:05:37 PDT

you write:

>I've got a question, Does Postgres support View indexing? How do
>I use these, just index the view or do I have to do something
>magic?

Views in postgres are implemented via rewrite rules.  To get indexing
you have to define indices on the base relation yourself.  The rewrite system
isn't smart enough to translate a 'define index' on the view into a 'define
index' on the base relation.


Jeff Meredith
mer@postgres.berkeley.edu