| From: | Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org> |
|---|---|
| To: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
| Cc: | Jeff Davis <jdavis-pgsql(at)empires(dot)org>, Michael Fuhr <mike(at)fuhr(dot)org>, Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>, "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index on a view?? |
| Date: | 2005-01-05 23:07:25 |
| Message-ID: | 41DC732D.4050103@visualdistortion.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ragnar Hafstað wrote:
>On Wed, 2005-01-05 at 13:03 -0800, Jeff Davis wrote:
>
>
>>On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
>>
>>
>>>On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
>>>
>>>
>>[snip]
>>
>>
>>
>>>PostgreSQL
>>>doesn't have materialized views per se but it does have functionality
>>>that can implement them.
>>>
>>>
>>>
>>Can you tell me what you mean by that?
>>
>>
>
>triggers, maybe ?
>
>gnari
>
>
Specifically, info can be found here:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robby Russell | 2005-01-05 23:25:48 | Re: PostgreSQL users on webhosting |
| Previous Message | Steve Crawford | 2005-01-05 22:59:34 | Re: SELECT WHERE NOT, is not working |