Re: Extending Regular Expression bounds limit of 255.

From: alvherre <alvherre(at)commandprompt(dot)com>
To: Brent DeSpain <bd(dot)postgres(at)gmail(dot)com>
Cc: Andrej <andrej(dot)groups(at)gmail(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Extending Regular Expression bounds limit of 255.
Date: 2010-05-28 15:14:44
Message-ID: 1275059495-sup-4074@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Excerpts from Brent DeSpain's message of jue may 27 18:55:55 -0400 2010:
> 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?

See regcomp.c; you'll have to recompile. The interesting constant is
DUPMAX (defined in regguts.h as per POSIX), but note that there's
arithmetic in repeat() with those values. I wouldn't recommend doing
any of this unless you have time to figure out whether the algorithms
are efficient for larger values though.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brent DeSpain 2010-05-28 15:44:28 Re: Extending Regular Expression bounds limit of 255.
Previous Message Jasen Betts 2010-05-28 10:31:03 Re: cast record type to array?