Re: Regex "embedded options" does only work on the whole pattern?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: matshyeq <matshyeq(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Regex "embedded options" does only work on the whole pattern?
Date: 2016-01-04 03:42:42
Message-ID: CAKFQuwYO-SvGk=x-y_85bqfqR-fkrp2eH35Gs+Y342KUAOJwYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jan 3, 2016 at 8:49 AM, matshyeq <matshyeq(at)gmail(dot)com> wrote:

> Does that mean these "EMBEDDED OPTIONS" can be only defined at the
> beginning of the pattern and therefore don't offer anything extra over *flags
> *option?
>

​Yes, this is how they behave. The most important difference is that:

column ~ 'regex' (i.e., the operator)

can only accept embedded switches since there is no place to write a formal
flag like you can with the functions.

​Though there is a case-insensitive operator as a usability feature the
other modes lack any external operator support.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Venkatesulu Jumbo 2016-01-04 03:42:49 Re: PostgreSQL GUI tools
Previous Message Gerdan Rezende dos Santos 2016-01-04 00:39:39 2 tuples to same chunk in toast table