inconsistent functionality with LIKE operator

Поиск
Список
Период
Сортировка
От Phuong Ma
Тема inconsistent functionality with LIKE operator
Дата
Msg-id 3AC2F17A.BFC50830@commandprompt.com
обсуждение исходный текст
Ответы Re: [SQL] inconsistent functionality with LIKE operator  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: inconsistent functionality with LIKE operator  (will trillich <will@serensoft.com>)
Список pgsql-general
I'm using PostgreSQL version 7.1, and I'm having trouble with the LIKE
statement.  How would I find the value "a\bc"?  I tried using the
backslash to escape it: LIKE 'a\\b%';

If I specify: LIKE 'a\\bc', then it works, but if I wanted it to look
for consecetive characters after the c, using the %, then it returns
other values besides what I'm looking for.

I also have the same problem with percent (%).  I have a test string
with the value "ab%c", and I want to look for that using LIKE.  I tried:
LIKE 'ab\%c', LIKE 'ab%%', and LIKE 'ab\%_', but these statements not
only returned what I was looking for, but also other values:
"abc","ABC", and "Abc".

Phuong

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] Please Help Can not connect to any database
Следующее
От: Chris Jones
Дата:
Сообщение: Re: explain shows lots-o-preliminary sorting