Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> The docs do hint at how to do it properly:
> "PERFORM create_mv(''cs_session_page_requests_mv'', my_query);"
> but this might be helpful to be pointed out explicitely:
> "PERFORM create_mv(''cs_session_page_requests_mv'', my_query);
> Note that the PERFORM replaces the SELECT in the query."
The 8.0 and up docs do indeed say that.
regards, tom lane