Re: Dollar in identifiers

Tom Lane wrote:
> Jan Wieck <JanWieck@Yahoo.com> writes:
> >     Could  you  live  with it when we don't allow a name to start
> >     with a dollar, but allow the dollar inside or at the  end  of
> >     the name?
>
> We had *better* not allow an identifier to start with $ --- or have
> you forgotten about parameters?

    Interestingly  enough,  allowing  it did no break anything in
    the regression test. And even PL/pgSQL functions are able  to
    deal with these objects out of the box.

> I tend to agree with Bruce on this; we have not seen any requests for
> this so far, and I don't much like the idea of decreasing our compliance
> with the standard without strong reason.
>
> I'm also concerned about changing the behavior of the lexer for
> parameter identifiers adjacent to keywords.  "select$1from foo"
> might be horrible coding style, but who's to promise that there
> are no applications out there that emit things like that?

    Does  *that* work currently? Which application could possibly
    emit such a statement. Parameters can only  occur  in  server
    side queries.  So someone must do that crap over SPI.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com