[PERFORM] Indexed views.

2005-08-04 Thread prasanna s 
Does postgres support indexed views/materialised views that some of the other databases support?

Thanks
Prasanna S

Re: [PERFORM] Indexed views.

2005-08-04 Thread Christopher Kings-Lynne 

No, unless you use some custom triggers.

prasanna s wrote:
Does postgres support indexed views/materialised views that some of the 
other databases support?


Thanks
Prasanna S



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Indexed views.

2005-08-04 Thread Laszlo Hornyak 

prasanna s wrote:

Does postgres support indexed views/materialised views that some of 
the other databases support?


Thanks
Prasanna S


Hi!

It is not supported, but perhaps this will help you: 
http://www.varlena.com/varlena/GeneralBits/Tidbits/matviews.html





---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly