Hello
2014-04-04 11:43 GMT+02:00 Tjibbe <tji...@rijpma.org>:
> I have a plpgsql function with:
>
>
> PERFORM * FROM answers(_h); --works fine.
> CREATE TEMP VIEW answers AS SELECT * FROM answers(_h); --gives error...
>
Inside view definition should not be plpgsql variable - this statement has
no plan - CREATE VIEW
probably you can do with dynamic SQL
EXECUTE 'CREATE TEMP VIEW answers AS SELECT * FROM answers(' ||
quote_literal(_h) || ')';
Regards
Pavel Stehule
> 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
>
