Re: order of (escaped) characters in regex range - Mailing list pgsql-general

From Merlin Moncure
Subject Re: order of (escaped) characters in regex range
Date
Msg-id CAHyXU0zubMZnEOLtyrR0ozT_K1XdmV-VcOUUrp5X8ibj1p49_w@mail.gmail.com
Whole thread Raw
In response to Re: order of (escaped) characters in regex range  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
On Tue, Dec 13, 2011 at 10:53 AM, David Johnston <polobo@yahoo.com> wrote:
> Aside from backward compatibility, and the various warnings, is there any
> reason to prefer dollar-quoting over a non-SQL-escaped string literal (i.e.,
> '3[A-Z\-\(\) ]'   ) ?

yeah -- because sooner or later you have to stick a single quote in
there (of course, you can double the ', but I personally think that's
awful).

merlin

pgsql-general by date:

Previous
From: Scot Kreienkamp
Date:
Subject: Re: initdb with lc-collate=C
Next
From: Rob Marjot
Date:
Subject: Re: order of (escaped) characters in regex range