2014-04-04 14:16 GMT+02:00 Tjibbe <tji...@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 > > Regards > > Tjibbe > > -- > +31 6 29401726 > tji...@rijpma.org > Jacobusstraat 185 > 3012 JM Rotterdam > > > On 4 April 2014 11:43, Tjibbe <tji...@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) >> >> -- >> +31 6 29401726 >> tji...@rijpma.org >> Jacobusstraat 185 >> 3012 JM Rotterdam >> > >
