Re: LIKE - bug or expected behaviour?

Поиск
Список
Период
Сортировка
От Jan-Peter Seifert
Тема Re: LIKE - bug or expected behaviour?
Дата
Msg-id 4AD9FB99.6010603@gmx.de
обсуждение исходный текст
Ответ на Re: LIKE - bug or expected behaviour?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: LIKE - bug or expected behaviour?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
Hello,

Tom Lane wrote:

>> SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE
'\_%\_username';
>
>> does also match views with names like table_username.
>
> Unless you have standard_conforming_strings turned on, those backslashes
> are going to be eaten by the string-literal parser.  So the LIKE code
> just sees '_%_username'.

a very belated thank you very much for the explanation. So it matched
every view ending on the user's name ...
Makes me wonder whether this query was broken to begin with or did this
change with time / introduction of standard conforming strings?

Thank you very much,

Peter

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

Предыдущее
От: rahimeh khodadadi
Дата:
Сообщение: Re: configuration kerberos in Postgre sql
Следующее
От: idris khanafi
Дата:
Сообщение: Error when running PG_DUMP