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
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