Re: GSoC - code of implementation of materialized views
Pavel Baroš <baros.p@seznam.cz>
From: Pavel Baros <baros.p@seznam.cz>
To: pgsql-hackers@postgresql.org
Date: 2010-06-25T18:24:32Z
Lists: pgsql-hackers
Attachments
- mv_v1.0.patch (text/x-patch) patch v1
> On http://github.com/pbaros/postgres can be seen changes and my attempt > to implement materialized views. The first commit to the repository > implements following: > > Materialized view can be created, dropped and used in SELECT statement. > > CREATE MATERIALIZED VIEW mvname AS SELECT ...; > DROP MATERIALIZED VIEW mvname [CASCADE]; > SELECT * FROM mvname; > > also works: > COMMENT ON MATERIALIZED VIEW mvname IS 'etc.'; > SELECT pg_get_viewdef(mvname); ... also you can look at enclosed patch.