Re: Comparing text field

Поиск
Список
Период
Сортировка
От Nik
Тема Re: Comparing text field
Дата
Msg-id 1145217629.428952.31320@u72g2000cwu.googlegroups.com
обсуждение исходный текст
Ответ на Re: Comparing text field  (Nirmalya Lahiri <nirmalyalahiri@yahoo.com>)
Список pgsql-general
It is possible that one had /r/n and the other just /n. I was doing the
comparison using psql.

The issue was not using LIKE and %.

I resolved the problem by removing chr(13) from both sides. So my
working query was had a where clause like this:

WHERE REPLACE(message, chr(13), '') = REPLACE('<long string>', chr(13),
'')


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

Предыдущее
От: "surabhi.ahuja"
Дата:
Сообщение: Re: hard shutdown of system
Следующее
От: "Danish"
Дата:
Сообщение: tsearch2 installation problem