Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5776: Unable to create view with parameter in PL/pgsql - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5776: Unable to create view with parameter in PL/pgsql
Date
Msg-id AANLkTik8TBP+h=fWuFuTgWe=zfbMtKxLD6TXceSY9uMd@mail.gmail.com
Whole thread Raw
In response to BUG #5776: Unable to create view with parameter in PL/pgsql  ("Andrey Galkin" <andvgal@gmail.com>)
Responses Re: BUG #5776: Unable to create view with parameter in PL/pgsql
List pgsql-bugs
Tree view 
On Tue, Nov 30, 2010 at 4:43 PM, Andrey Galkin <andvgal@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05776
> Logged by: =A0 =A0 =A0 =A0 =A0Andrey Galkin
> Email address: =A0 =A0 =A0andvgal@gmail.com
> PostgreSQL version: 9.0.1
> Operating system: =A0 Debian unstable
> Description: =A0 =A0 =A0 =A0Unable to create view with parameter in PL/pg=
sql
> Details:
>
> Below is simple test case. Perhaps, I'm doing something wrong.

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

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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: not all pg_stat_database fields reset after pg_stat_reset()
Next
From: "Reegun Richard.J"
Date:
Subject: BUG #5789: asking password