Postgres Pro
Downloads
Home   >   mailing lists

Re: Extending Regular Expression bounds limit of 255. - Mailing list pgsql-sql

From Brent DeSpain
Subject Re: Extending Regular Expression bounds limit of 255.
Date
Msg-id AANLkTikbjNOsDwlnfUcjS9G2CzgWcnp8NpS48v9m_TSp@mail.gmail.com
Whole thread Raw
In response to Re: Extending Regular Expression bounds limit of 255.  (Brent DeSpain <bd.postgres@gmail.com>)
Responses Re: Extending Regular Expression bounds limit of 255.  (alvherre <alvherre@commandprompt.com>)
List pgsql-sql
Tree view
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?

Brent DeSpain
Schweitzer Engineering Laboratories, Inc.


On Thu, May 27, 2010 at 4:44 PM, Brent DeSpain <bd.postgres@gmail.com> wrote:
No.  Strangely enough they don't in enforce this limit.


Brent DeSpain
Schweitzer Engineering Laboratories, Inc.


On Thu, May 27, 2010 at 2:59 PM, Andrej <andrej.groups@gmail.com> wrote:
On 28 May 2010 07:33, Brent DeSpain <bd.postgres@gmail.com> wrote:
> In the docs
> http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE
> it says that Regular Expression bounds {m,n} that m and n can be 0-255.  Is
> there a way to extend the upper limit.  We are trying to be consistent
> between Regular Expressionimplementation an the other implementations do not
> have this limit.
Interesting.  The POSIX standard for REs dictates this limit; which
implementations
you're using don't adhere to it?


Cheers,
Andrej




--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm


pgsql-sql by date:

Previous
From: Brent DeSpain
Date:
Subject: Re: Extending Regular Expression bounds limit of 255.
Next
From: Jasen Betts
Date:
Subject: Re: cast record type to array?