Re: create temp view from function inside plpgsql function.

Re-posting, see quote


David Johnston wrote
>
> Pavel Stehule wrote
>> 2014-04-04 14:16 GMT+02:00 Tjibbe <

>> tjibbe@

>> >:
>>
>>> 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
> Yet, IIRC, if you had done a CREATE TEMP TABLE instead of view the query
> would have worked just fine.  The issue is with CREATE VIEW specifically
> because the query itself is part of the final content whereas for CREATE
> TABLE the query is only used to generate the data which is then stored.
>
> David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/create-temp-view-from-function-inside-plpgsql-function-tp5798658p5799286.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.