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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
