Bruce Momjian wrote: > > Peter Eisentraut wrote: > > Tom Lane writes: > > > > > Quite awhile back, we had a discussion about removing "$" from the set > > > of allowed characters in operator names, and instead allowing it as a > > > non-first character in identifiers. > > > > I agree with the first one, but does it have to imply the second? > > I believe he wanted the second because Oracle supports it, and some > Oracle apps use that feature. I think in the old days, before > underscore, Oracle used $ for space (double yuck).
Dollar is not allowed as per SQL spec. And I think Oracle discouraged people from using it, but used it in their own stuff. Good way to avoid any possible conflicts and I would've liked our version of it to be pg$ instead of pg_ ... I think that's a bit too much to ask for, is it? The problem is, discouraged or not, if there's a slot people will stick something into ... meaning if it accepts a dollar, to hell with vendor recommendations! Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
