Re: create temp view from function inside plpgsql function.
| От | Pavel Stehule |
|---|---|
| Тема | Re: create temp view from function inside plpgsql function. |
| Дата | |
| Msg-id | CAFj8pRCqFxpexXco8wF7vL2vNvJxDzUzpUH+=fnSrb52AJfcFw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: create temp view from function inside plpgsql function. (Tjibbe <tjibbe@rijpma.org>) |
| Список | pgsql-general |
2014-04-04 14:16 GMT+02:00 Tjibbe <tjibbe@rijpma.org>:
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@rijpma.org> 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)
В списке pgsql-general по дате отправления: