Daniel P. Katz wrote:
>
> Hi.
>
> Does PostgreSQL 7.0 support materialized views? Sorry if this
> is a FAQ, but I didn't find it in the FAQ list, the users guide, or
> the archives for this list.
No.
PostgreSQL uses a query rewriting technique to implement
views. That means, that before any data is retrieved by a
query, it is rewritten as if the user did use the relations
and qualifications of the view. So the query execution
engine is never faced with views, it only hits real tables.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #