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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
