Re: BUG #5776: Unable to create view with parameter in PL/pgsql

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andrey Galkin <andvgal(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5776: Unable to create view with parameter in PL/pgsql
Date: 2010-12-13 01:39:32
Message-ID: AANLkTik8TBP+h=fWuFuTgWe=zfbMtKxLD6TXceSY9uMd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Nov 30, 2010 at 4:43 PM, Andrey Galkin <andvgal(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5776
> Logged by:          Andrey Galkin
> Email address:      andvgal(at)gmail(dot)com
> PostgreSQL version: 9.0.1
> Operating system:   Debian unstable
> Description:        Unable to create view with parameter in PL/pgsql
> Details:
>
> Below is simple test case. Perhaps, I'm doing something wrong.

You can accomplish what you're trying to do using EXECUTE.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Reegun Richard.J 2010-12-13 06:58:11 BUG #5789: asking password
Previous Message Tom Lane 2010-12-12 20:13:08 Re: not all pg_stat_database fields reset after pg_stat_reset()