From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Radu-Adrian Popescu <radu.popescu@aldratech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL function parse error ?
Date: Thu, 9 Jan 2003 09:00:31 -0800 (PST)
Message-ID: <20030109085635.I92199-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <777.1042127826@sss.pgh.pa.us>
On Thu, 9 Jan 2003, Tom Lane wrote:
> Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> > On Thu, 9 Jan 2003, Radu-Adrian Popescu wrote:
> >> Why is that ? Because the >$ does not exist, not in the default operator
> >> list
>
> > i think the parser is built with yacc, (not "from scratch code") so
> > maybe finding if ">$" is in the specific DB's operators
> > would require code that whould slower the whole parsing
> > process (imagine what it means for performance).
> Because of these issues, the question of whether ">$" actually is
> defined as an operator in a particular installation is irrelevant to
> how we split character strings into tokens. The only way we have to
> adjust this behavior is by changing the rules about what an operator
> name could be, for everyone.
Although the rules could be similar to those for + and - at the end of
operator strings (no $ at the end of an operator unless it contains
characters not normally in SQL92 operators). I'm not sure that
behavior is sensible either, but if someone wanted to
do it for their own installation it's about a 2 line patch.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, tgl@sss.pgh.pa.us, achill@matrix.gatewaynet.com, radu.popescu@aldratech.com
Subject: Re: SQL function parse error ?
In-Reply-To: <20030109085635.I92199-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox