Re: Index on a view??

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?

You can use triggers to create your materialized views.


>
> Regards,
>     Jeff Davis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL