Re: order of (escaped) characters in regex range

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: rob(at)marjot-multisoft(dot)com, Szymon Guz <mabewlun(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: order of (escaped) characters in regex range
Date: 2011-12-13 16:59:13
Message-ID: CAHyXU0zubMZnEOLtyrR0ozT_K1XdmV-VcOUUrp5X8ibj1p49_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 13, 2011 at 10:53 AM, David Johnston <polobo(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message anisoptera 2011-12-13 20:37:57 query for all values linked to a field
Previous Message Scot Kreienkamp 2011-12-13 16:58:00 Re: initdb with lc-collate=C