Re: named parameters in SQL functions

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>   
>> At Tom's suggestion I am looking at allowing use of parameter names in 
>> SQL functions instead of requiring use of $1 etc. That raises the 
>> question of how we would disambiguate a parameter name from a column 
>> name.
>>     
>
> Throw error if ambiguous.  We already resolved this in the context of
> plpgsql.
>
>             
>   

Well, if the funcname.varname gadget will work, as you suggest elsewhere 
it could, I think that would suffice. I had assumed that was just 
something in the plpgsql engine.

cheers

andrew