Re: create temp view from function inside plpgsql function.

From: Tjibbe <tjibbe(at)rijpma(dot)org>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: create temp view from function inside plpgsql function.
Date: 2014-04-04 12:16:21
Message-ID: CAF_dx11sED1CSX33_2V=HA2SZ07ZpzvK9CPiHyxmoFbW-EZWxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks that works!

Little bit confusing ERROR.

Regards

Tjibbe

--
+31 6 29401726
tjibbe(at)rijpma(dot)org
Jacobusstraat 185
3012 JM Rotterdam

On 4 April 2014 11:43, Tjibbe <tjibbe(at)rijpma(dot)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
> tjibbe(at)rijpma(dot)org
> Jacobusstraat 185
> 3012 JM Rotterdam
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2014-04-04 12:32:06 Re: hstore - jsonb
Previous Message Ray Stell 2014-04-04 12:11:42 Re: Linux vs FreeBSD