Re: Create view is not accepting the parameter in postgres functions

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Divyaprakash Y <divyaprakash(dot)y(at)celstream(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Create view is not accepting the parameter in postgres functions
Date: 2012-06-13 17:41:42
Message-ID: CAHyXU0xCiONWOvAsJ4c=2T2_TjpXcWCWbdinJOGhTpqV_ozYiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 13, 2012 at 12:25 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-06-13 18:32:21 Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!
Previous Message Little, Douglas 2012-06-13 17:25:31 composite type use in pl/gpsql