Re: Regular expression character escape

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ronan Dunklau <rdunklau(at)gmail(dot)com>
Cc: Heiko Wundram <modelnine(at)modelnine(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Regular expression character escape
Date: 2012-02-24 17:21:24
Message-ID: 22268.1330104084@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ronan Dunklau <rdunklau(at)gmail(dot)com> writes:
> Unfortunately for my use case, "too much" quoting can lead to errors in
> postgresql.

AFAIR, the only stuff that's unsafe to insert a backslash before
is ASCII letters. This is documented in the fine print discussing
regular expressions, btw.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Willem Buitendyk 2012-02-24 18:20:28 Re: Upgrade to 9.1 causing function problem
Previous Message Tom Lane 2012-02-24 17:09:38 Re: invalid memory alloc request size 1765277700 Error Question