Re: Index on a view?? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Index on a view??
Date
Msg-id 41DC58AF.6070208@commandprompt.com
Whole thread Raw
In response to Re: Index on a view??  (Jeff Davis <jdavis-pgsql@empires.org>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Index on a view??
Next
From: Michael Fuhr
Date:
Subject: Re: Trigger Question