I get the following error when trying to create a view with the following trivial example. SQL error: ERROR: rules on SELECT must have action INSTEAD SELECT In statement: CREATE VIEW "nutrition"."test_view" AS SELECT 2 as two, 3 as three INTO TEMP temp_table; SELECT *,two+three as five FROM temp_table; If I rewrite the statement to maybe make more sense: SQL error: ERROR: temporary tables cannot specify a schema name In statement: SELECT 2 as two, 3 as three INTO TEMP nutrition.temp_table; CREATE VIEW "nutrition.test_view" AS SELECT *,two+three as five FROM nutrition.temp_table; So the question is how do I use the powerful feature of temporary tables with views? And if this is not possible, how do I do something similar for optimization reasons (ie pretend "two+three as five" is some very expensive operation and "two" and "three" were also expensive operations)? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
