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

From Andrew Chernow
Subject Re: named parameters in SQL functions
Date
Msg-id 4B005CE3.6070900@esilo.com
Whole thread Raw
In response to Re: named parameters in SQL functions  (Greg Stark <gsstark@mit.edu>)
Responses Re: named parameters in SQL functions
List pgsql-hackers
> The point is that $ is a perfectly valid SQL identifier character and
> $foo is a perfectly valid identifier. You can always quote any
> identifier (yes, after case smashing) so you would expect if $foo is a
> valid identifier then "$foo" would refer to the same identifier.
> 

This case already exists via $1 and "$1".  Making '$' a marker for parameters 
wouldn't introduce it.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Summary and Plan for Hot Standby
Next
From: Andrew Gierth
Date:
Subject: Re: Aggregate ORDER BY patch