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

From David E. Wheeler
Subject Re: named parameters in SQL functions
Date
Msg-id 1D6D5B84-4AB8-4738-A156-420DC241F5BC@kineticode.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
Re: named parameters in SQL functions
List pgsql-hackers
On Nov 15, 2009, at 11:21 AM, Greg Stark wrote:

> No, that's not the same.
> 
> 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.
> You're introducing a meaning for $foo but saying there's no valid way
> to quote the identifier to get the same thing. And worse, if you do
> quote it you get something else entirely different.

$foo should be killed off as a valid identifier, IMNSHO.

But failing that, some other sigil would be most welcome.

Best,

David


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: named parameters in SQL functions
Next
From: Simon Riggs
Date:
Subject: Re: Summary and Plan for Hot Standby