Am 24.02.2012 17:40, schrieb Ronan Dunklau:
> On 24/02/2012 17:09, Heiko Wundram wrote:
>> Use the corresponding function of your programming language/framework of
>> choice. E.g. Python delivers this as re.escape().
>
> Thank you, but as I wrote in the original post, I don't know how
> postgresql and python differ in their regexp syntax. Specifically, I
> know that re.escape escapes any non-alphanumeric character, including
> accented letters.
>
> If you have any evidence proving that everything will work fine with
> re.escape, I'll be more than happy to use it.
This will work (AFAICT, _and_ as far as I've used it): the regex-syntax
of Python is a superset of the regex-syntax of PostgreSQL (both are
based on PCRE, not on the library, but the syntax), and as such you'll
possibly do "too much" quoting, but never too little when simply using
the Python-builtin.
--
--- Heiko.