From: Zalman Stern <zalman@netcom.com>
To: maillist@candle.pha.pa.us
Cc: herouth@oumail.openu.ac.il
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] How match percent sign in SELECT using LIKE?
Date: Tue, 16 Mar 1999 12:51:41 -0800 (PST)
Message-ID: <199903162051.MAA01651@netcom15.netcom.com> (raw)
In-Reply-To: <199903162024.PAA18319@candle.pha.pa.us>
Bruce Momjian wrote:
> I agree we should allow ESC, but that would make LIKE a trinary
> operation, rather than a binary. If you want really confusing, the code
> for LIKE really does:
>
> | a_expr LIKE a_expr
> { $$ = makeIndexable("~~", $1, $3); }
>
> so it maps LIKE to a binary operator "~~". How do we map that into a
> trinary operator, which we don't support? Doesn't really seem worth it.
>
> I can add an item to the TODO list if you wish?
One useful and probably not too hard thing to do is to allow ESCAPE '\' on
the end of the LIKE clause. Any character other than '\' will be an error.
This allows Postgres users to write compliant SQL code that can be used
with other databases.
Another approach is to "rewrite" the match string at parse time. If it is a
known constant, you can do the whole job there. Otherwise, you'd insert an
extra node in the parse tree which does the rewrite just before calling hte
"~~" operator. (I am assuming the match string can be a general expression
and that you can add a function of two arguments which rewrites the first
argument using the second argument as the escape character. This is of
course not the utmost of micro efficiency, but I doubt it would matter
much.)
But I don't have in depth knowledge of the Postgres SQL parser and
evaluator so I may be way off base.
-Z-
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: zalman@netcom.com, maillist@candle.pha.pa.us, herouth@oumail.openu.ac.il
Subject: Re: [SQL] How match percent sign in SELECT using LIKE?
In-Reply-To: <199903162051.MAA01651@netcom15.netcom.com>
References: <199903162024.PAA18319@candle.pha.pa.us> <199903162051.MAA01651@netcom15.netcom.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