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

From Peter Eisentraut
Subject Re: named parameters in SQL functions
Date
Msg-id 1258373875.23638.3.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to named parameters in SQL functions  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On sön, 2009-11-15 at 12:37 -0500, Andrew Dunstan wrote:
> 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. Essentially, ISTM, we could use some special marker such as @ 
> (c.f. SQL Server) or : (c.f. ecpg) or else we could have some rule that 
> says which name takes precedence. I think I prefer a special marker, 
> other things being equal. Is there a standard on this?

Yes, search the SQL standard for <SQL parameter reference>.



pgsql-hackers by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: ECPG patch 4, out-of-scope cursor support in Informix-mode
Next
From: Ron Mayer
Date:
Subject: Re: ORDER BY vs. volatile functions