Re: Create view is not accepting the parameter in postgres functions - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Create view is not accepting the parameter in postgres functions
Date
Msg-id CAHyXU0xCiONWOvAsJ4c=2T2_TjpXcWCWbdinJOGhTpqV_ozYiA@mail.gmail.com
Whole thread Raw
In response to Re: Create view is not accepting the parameter in postgres functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Jun 13, 2012 at 12:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
>> The CREATE VIEW statement does not allow parameterized arguments
>> apparently.
>
> Well, no.  What would it mean?  The view is likely to outlast the
> existence of the function argument.

right -- it's quite sensible even if superficially unusual: for
vanilla queries there is a very clear line between what can be
parameterized and what can't. CREATE VIEW looks like a query but does
something completely different and so obeys a different set of rules.

merlin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create view is not accepting the parameter in postgres functions
Next
From: Bruce Momjian
Date:
Subject: Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!