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

On 13 Jun 2012, at 7:31, Divyaprakash Y wrote:

> Hi,
>
> Is the following postgres function correct?
>
> CREATE OR REPLACE FUNCTION "MyFun"("IdArgs" INTEGER)

Named parameters --------------------^^^


>                CREATE VIEW "A"  AS SELECT * FROM "B" WHERE "Id" = $1;


Positional parameters ---------------------------------------------^^

You can't mix those. I don't think SQL functions support named parameters, so using positional parameters throughout
wouldbe the solution. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.