Re: [GENERAL] Escaping regexp special characters in field value

2012-11-21 Thread David Johnston
Wednesday, November 21, 2012 4:39 AM To: Postgres General Postgres General Subject: [GENERAL] Escaping regexp special characters in field value 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 ~*. O

[GENERAL] Escaping regexp special characters in field value

2012-11-21 Thread Allan Kamau
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 t