From: Herouth Maoz <herouth@oumail.openu.ac.il>
To: Dan Wilson <dan_wilson@geocities.com>
To: pgsql general <pgsql-general@postgreSQL.org>
To: pgsql-sql@postgreSQL.org
Subject: Re: [GENERAL] escaping wildcard chars
Date: Mon, 26 Jul 1999 15:39:36 +0300
Message-ID: <l03130304b3c20462e0db@[147.233.159.109]> (raw)
In-Reply-To: <008801bed726$ffdc2860$ac0bfea9@dwilson>
At 08:16 +0300 on 26/07/1999, Dan Wilson wrote:
> SELECT typname from pg_type WHERE NOT LIKE '_%'
>
> It gives me an empty set.
>
> Is there any way to escape the underscore. I tried to use '\_%', but that
> didn't help. Any suggestions?
Yes. Use '\\_%' instead. You see, a backslash is interpreted immediately as
"take the next char literally". This passes the underscore literally to
LIKE. Which is the same as '_%'. If you put a double backslash, the first
backslash takes the second one literally, thus passing '\_%' to LIKE. And
then LIKE knows that it should treat the underscore as non-special.
Ugly, ugly. I think we had a discussion either here or in one of the other
lists regarding the ESCAPE clause to LIKE. This behavior means that even if
we write ESCAPE '\', it won't work (Actually, it should be '\\'.
I really hate those backslashes. They are blatantly incompatible with SQL92
and will cause standard SQL to fail on Postgres, (and of course, Postgres
code to fail on other databases). There should be a setting, either in the
backend or in a SET command, such as "BACKSLASH_BEHAVIOR", which will be
either "literal" or "escape". It can default to the current behavior
(namely "escape") so that current code won't fail, but will enable people
to write sane standard code.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
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: herouth@oumail.openu.ac.il, dan_wilson@geocities.com, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] escaping wildcard chars
In-Reply-To: <l03130304b3c20462e0db@[147.233.159.109]>
References: <008801bed726$ffdc2860$ac0bfea9@dwilson> <l03130304b3c20462e0db@[147.233.159.109]>
* 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