No, you can only create an index on the underlying tables. A view is a
virtual realtion, not a physical one, so what would the index point to?
Any functionality you need you should be able to get with functional
indexes.
Perhaps if/when postgresql gets materialized views an index on a view
might be useful.
Regards,
Jeff Davis
On Wed, 2005-01-05 at 20:15 +0100, Joost Kraaijeveld wrote:
> Hi all,
>
> Is it possible to create an index on a view?
>
> Groeten,
>
> Joost Kraaijeveld
> Askesis B.V.
> Molukkenstraat 14
> 6524NB Nijmegen
> tel: 024-3888063 / 06-51855277
> fax: 024-3608416
> e-mail: J.Kraaijeveld@Askesis.nl
> web: www.askesis.nl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org