| 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: | Whole Thread | Raw Message | 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
| 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? |