Re: Generic regex escape function?

From: David Wheeler <david(at)kineticode(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "Jon Asher" <jon(at)vagabond-software(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: Generic regex escape function?
Date: 2004-11-17 18:38:44
Message-ID: E95B1CE0-38C7-11D9-B400-000A95B9602E@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

On Nov 16, 2004, at 9:12 PM, Josh Berkus wrote:

> Thanks for the advice. Actually, as it turns out, I can take
> advantage of
> some of the escape codes supported by the tri-mode regex support in
> postgres.
> If I pass:
>
> '***=<some-user-string>'
>
> Then <some-user-string> will be interpreted as literal characters with
> no
> regex special chars.

The...what? What is "tri-mode regex support"? And what if
<some-user-string> has a single quote (') in it?

Regards,

David

In response to

Responses

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2004-11-17 19:03:48 Re: Generic regex escape function?
Previous Message Josh Berkus 2004-11-17 05:12:29 Re: Generic regex escape function?