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

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
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 07:12:49
Message-ID: 4FD83D71.4090508@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/13/2012 03:06 PM, Alban Hertroys wrote:

> Named parameters --------------------^^^
> Positional parameters ---------------------------------------------^^
>
> You can't mix those. I don't think SQL functions support named parameters, so using positional parameters throughout would be the solution.

Yep, that's the immediate cause of failure, and I missed that in my
reply so I'm answering the *next* question. Whoops, sorry.

If you remove the name and use positional style, the function still
fails for a different reason, as per my post following.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-06-13 07:16:15 Re: Create view is not accepting the parameter in postgres functions
Previous Message Craig Ringer 2012-06-13 07:09:18 Re: Create view is not accepting the parameter in postgres functions