Re: Extending Regular Expression bounds limit of 255.

From: Brent DeSpain <bd(dot)postgres(at)gmail(dot)com>
To: Andrej <andrej(dot)groups(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Extending Regular Expression bounds limit of 255.
Date: 2010-05-27 22:55:55
Message-ID: AANLkTikbjNOsDwlnfUcjS9G2CzgWcnp8NpS48v9m_TSp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)postgres(at)gmail(dot)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(dot)groups(at)gmail(dot)com> wrote:
>
>> On 28 May 2010 07:33, Brent DeSpain <bd(dot)postgres(at)gmail(dot)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
>>
>
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Harrie Rodenbach 2010-05-28 07:32:40 Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link
Previous Message Brent DeSpain 2010-05-27 22:44:00 Re: Extending Regular Expression bounds limit of 255.