Re: Dollar in identifiers

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jan Wieck" <JanWieck(at)yahoo(dot)com>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "PostgreSQL HACKERS" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Dollar in identifiers
Date: 2003-01-10 01:36:41
Message-ID: GNELIHDDFBOCMGBFGEFOGEPECEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Change it - but just put it in the release notes :)

Chris

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Friday, 10 January 2003 1:10 AM
> To: Jan Wieck; Peter Eisentraut
> Cc: PostgreSQL HACKERS
> Subject: Re: [HACKERS] Dollar in identifiers
>
>
> 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. (It'd have to be non-first to avoid
> ambiguity with parameter symbols "$nnn".) See, eg,
> http://archives.postgresql.org/pgsql-hackers/2001-08/msg00629.php
>
> That discussion petered out without any definite consensus being
> reached, but I think it's time to reconsider the idea. We're getting
> flak about "x<$n" being parsed as "x <$ n" rather than "x < $n" (see
> current thread in pgsql-sql). While this has always been a hazard for
> SQL and plpgsql function writers, it is now also a hazard in direct
> SQL, if you use PREPAREd queries. So I think the importance of avoiding
> such problems has moved up a notch as of 7.3.
>
> So, I'd like to put that proposal back on the table. Comments anyone?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-01-10 03:48:28 Prepared statements question
Previous Message Jan Wieck 2003-01-09 22:49:55 Re: Dollar in identifiers