Re: Escaping regexp special characters in field value

ILIKE is probably better - without an escape:

WHERE field1 ILIKE field2 ESCAPE ''

You could also try:

WHERE upper(field1) = upper(field2)

David J.

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Allan Kamau
Sent: 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 ~*.

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.