Re: weird quote bug

Поиск
Список
Период
Сортировка
От Shane Wright
Тема Re: weird quote bug
Дата
Msg-id 200306301306.17828.me@shanewright.co.uk
обсуждение исходный текст
Ответ на Re: weird quote bug  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список pgsql-general
> > They are identical!  I can't work out whats going on!  Please, if anyone
> > can see what's wrong it'll stop me careering into my early grave!
>
> I've never tried this but the docs for LIKE (secfion 6.6.1 in the 7.3
> docs) say that to match a literal \ you need to type \\\\. An alternative
> might be to try adding an ESCAPE '' clause at the end (also in the same
> doc section).

Ah.  I had soooo read that bit of the manual - must have missed it.  Phew it works now!

Thanks (and thanks to the others who answered my question!)

Cheers

Shane


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

Предыдущее
От: "Henrik Steffen"
Дата:
Сообщение: Cannot create unique index
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: tweaking PG and "machine health".