Re: Escaping regexp special characters in field value
| От | David Johnston |
|---|---|
| Тема | Re: Escaping regexp special characters in field value |
| Дата | |
| Msg-id | 023601cdc7ee$1b9277a0$52b766e0$@yahoo.com обсуждение исходный текст |
| Ответ на | Escaping regexp special characters in field value (Allan Kamau <kamauallan@gmail.com>) |
| Список | pgsql-general |
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@postgresql.org [mailto:pgsql-general-owner@postgresql.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.
В списке pgsql-general по дате отправления: