Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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