From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Joe <dev@freedomcircle.net>
To: Aaron Bono <postgresql@aranya.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Repetitive code
Date: Fri, 16 Jun 2006 07:08:00 -0700 (PDT)
Message-ID: <20060616140800.82760.qmail@web31802.mail.mud.yahoo.com> (raw)
In-Reply-To: <4492B248.7040406@freedomcircle.net>
> AFAIK PostgreSQL does not support materialized views but it's
> interesting that you mention that because in essence the query is used
> to materialize a view, i.e., it's part of an INSERT / SELECT into a
> table which is then joined back to the other tables to construct a web
> page as well as an RSS feed.
This thread:
http://archives.postgresql.org/pgsql-performance/2006-06/msg00324.php
mentions the use of materialized views in postgresql. See:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
However, I am not sure if this link shows how postgresql supports materialized views or if it just
shows how to simulate a materialized view with procedural code.
Either way, I thought it might be of interest to you.
Regards,
Richard Broersma Jr.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, dev@freedomcircle.net, postgresql@aranya.com
Subject: Re: Repetitive code
In-Reply-To: <20060616140800.82760.qmail@web31802.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox