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)
requesesfrom Toronto as well pretty soon I guess.
The thing is that the dollar isn't mentioned in the definition of the <SQL terminal character>
(chapter5.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@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com