Re: Dollar in identifiers

Bruce Momjian wrote:
> > I'm not sure if it's according to or violating the standard.
> > But most other databases allow a '$' inside of identifiers.
> > Well, most of them recommend not to use it, but hey guy's,
> > what's a recommendation for a programmer?
> >
> > In order to lower porting issues, I think it'd be nice to add
> > that to PostgreSQL as well. It's two more characters in
> > scan.l and doesn't break the regression test.
> >
> > Objections?
>
> Yes. We would move from standard C identifiers to $ identifiers. We
> have had zero requests for this so I see no need to add it.

Standard C? I was talking about *allowing* the dollar
character in table-, column-, function-names!

And not all requests show up directly on the mailing lists
any more. We'll see those (compatibility) requeses from
Toronto as well pretty soon I guess.

The thing is that the dollar isn't mentioned in the
definition of the <SQL terminal character> (chapter 5.1 of
SQL3) at all. But all DB vendors seem to treat it at least as
<SQL language identifier part>.

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?

Jan

--

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

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