Hello
2014-04-04 11:43 GMT+02:00 Tjibbe <tjibbe@xxxxxxxxxx>:
I have a plpgsql function with:PERFORM * FROM answers(_h); --works fine.CREATE TEMP VIEW answers AS SELECT * FROM answers(_h); --gives error...
Inside view definition should not be plpgsql variable - this statement has no plan - CREATE VIEW
probably you can do with dynamic SQL
EXECUTE 'CREATE TEMP VIEW answers AS SELECT * FROM answers(' || quote_literal(_h) || ')';
Regards
Pavel Stehule
Why I get this error:ERROR: column \"_h\" does not exist\nLINE 1: ...TEMP VIEW answers AS SELECT * FROM antwoorden_view(_h)
