Re: Index on a view??

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
Cc: 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 21:14:23
Message-ID: 41DC58AF.6070208@commandprompt.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-05 21:17:37 Re: Trigger Question
Previous Message Jeff Davis 2005-01-05 21:03:25 Re: Index on a view??