Escaping regexp special characters in field value - Mailing list pgsql-general

From Allan Kamau
Subject Escaping regexp special characters in field value
Date
Msg-id CAF3N6oQVm-o2qSU3knSjNuAVJ8XwPW3gGphuo3_mWxs9eAMJ7w@mail.gmail.com
Whole thread Raw
Responses Re: Escaping regexp special characters in field value  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
I do have a field for which I want to perform a join with some other field in another table using case without case sensitivity perhaps using ~*.
One of this fields may contain + characters or unbalanced parenthesis. Is there a way or some function that may mask out the regexp awareness of any of these characters if they appear the field values.

Should I need to write a function to escape each of these characters by placing a "\" character before it?

Allan.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Postgresql - 8.3 Replication in windows
Next
From: Jasen Betts
Date:
Subject: Re: PostgresQL intallation error