2014-04-04 14:16 GMT+02:00 Tjibbe <tjibbe@xxxxxxxxxx>:
Thanks that works!Little bit confusing ERROR.
yes, it could be - but hard to fix it, because it is based on cooperation two worlds - plpgsql and SQL - and it is sometimes not simple.
When you understand how plpgsql interpret use variables in SQL queries, then you understand to this message. Simple rule - never use plpgsql variables in DDL
Regards
Pavel Stehule
Pavel Stehule
Regards
TjibbeOn 4 April 2014 11:43, Tjibbe <tjibbe@xxxxxxxxxx> wrote:I have a plpgsql function with:PERFORM * FROM answers(_h); --works fine.CREATE TEMP VIEW answers AS SELECT * FROM answers(_h); --gives error...Why I get this error:ERROR: column \"_h\" does not exist\nLINE 1: ...TEMP VIEW answers AS SELECT * FROM antwoorden_view(_h)
