Re: Comparing text field - Mailing list pgsql-general

From Nik
Subject Re: Comparing text field
Date
Msg-id 1145217629.428952.31320@u72g2000cwu.googlegroups.com
Whole thread Raw
In response to Re: Comparing text field  (Nirmalya Lahiri <nirmalyalahiri@yahoo.com>)
List 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 by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: Re: hard shutdown of system
Next
From: "Danish"
Date:
Subject: tsearch2 installation problem