Re: named parameters in SQL functions - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: named parameters in SQL functions
Date
Msg-id 4B00A94C.2090105@dunslane.net
Whole thread Raw
In response to Re: named parameters in SQL functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: named parameters in SQL functions
List pgsql-hackers

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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: patch - Report the schema along table name in a referential failure error message
Next
From: Robert Haas
Date:
Subject: Re: Patch committers