Re: IS IT POSSIBLE TO CREATE INDEX ON VIEW IN POSTGRE
От | Shridhar Daithankar |
---|---|
Тема | Re: IS IT POSSIBLE TO CREATE INDEX ON VIEW IN POSTGRE |
Дата | |
Msg-id | 3DBD792D.19997.1022C4DE@localhost обсуждение исходный текст |
Ответ на | Re: IS IT POSSIBLE TO CREATE INDEX ON VIEW IN POSTGRE (Savita <savita@india.hp.com>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: