From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Extending Regular Expression bounds limit of 255.
Date: 30 May 2010 10:37:59 GMT
Message-ID: <httf67$5rf$1@reversiblemaps.ath.cx> (raw)
References: <AANLkTinSlZ_53lw9hAzQTd4bSFlR1_jmzgpbvTSYc3oi@mail.gmail.com>
<AANLkTimcCsHFFlknF_KBXV5mPTqLrW_LhST0GN4ONOYC@mail.gmail.com>
<AANLkTil49TqqzY3yQQFU-gGNT4KaVUjz1o5QHQGcYLZg@mail.gmail.com>
<AANLkTikbjNOsDwlnfUcjS9G2CzgWcnp8NpS48v9m_TSp@mail.gmail.com>
<htqq7f$4g9$2@reversiblemaps.ath.cx>
<m38w72y1se.fsf@passepartout.tim-landscheidt.de>
On 2010-05-29, Tim Landscheidt <tim@tim-landscheidt.de> wrote:
> Jasen Betts <jasen@xnet.co.nz> wrote:
>
>>> It looks like most of our tools are using the Perl version of regular
>>> expressions with an upper limit of a bound being 32766. Is there any way to
>>> change this in PG? Or can I change from POSIX to Perl?
>
>> perhaps you can do something in pl-perl?
>
>> posix regular expressions are different to perl regular expressions in
>> several ways.
>
> Another last resort possibility would of course be to "pre-
> compile" the regular expressions from "A{2000}" to
> "A{255}A{255}A{255}A{255}A{255}A{255}A{255}A{215}"
(A{200}){10}
might work better.
> (with the headaches of "A{1000,2000}" left as an exercise to the read-
> er :-)).
easy enoungh to write, but probably easy to write an expression with
factorial complexity too, but this one should work, having at worst
two ways of matching any string.
(A{200}){5,9}A{0,200}
but
(A{5,10}){200}
is asking for trouble.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: Extending Regular Expression bounds limit of 255.
In-Reply-To: <httf67$5rf$1@reversiblemaps.ath.cx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox