Re: IS IT POSSIBLE TO CREATE INDEX ON VIEW IN POSTGRE

On 28 Oct 2002 at 17:04, Savita wrote:

> no raply for this question is this question is not making any sense.

OK, I will try..

>
> Savita wrote:
>
> > Hi All,
> >
> > I just wanted to know is it possible to create indexes on view and update
> > statement in postgres.

In postgres, views are implemented using rules. So for updating views you might
want to right your own rule. So with little coding it should be possible to
have updatable views, though postgresql does not support them out of box.

About creating index on a view, my experiments tell me it's not possible. It
has to be relation. But given that indexes are usually used for making searches
faster, you might consider creating indexes on original table based on query
that forms the view. I underastand this is not a complete solution for your
problem, but should help a bit..

HTH

Bye
Shridhar

--
Ambiguity: Telling the truth when you don't mean to.