Skip site navigation (1) Skip section navigation (2)

Re: precompiling regular expressions in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Hurt <bhurt(at)janestcapital(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: precompiling regular expressions in plpgsql
Date: 2006-07-31 20:56:04
Message-ID: 13643.1154379364@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Brian Hurt <bhurt(at)janestcapital(dot)com> writes:
> Now, the strings that I'm using as the pattern as a regular expression 
> really are constant, even if they don't look like it to postgres.  Is it 
> possible to precompile these expressions (basically, build up the tables 
> for the DFA engine ahead of time) in plpgsql?

This already happens internally --- you might need to increase the size
of the cache in src/backend/utils/adt/regexp.c ...

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Brian HurtDate: 2006-08-01 19:06:49
Subject: GRANT role TO PUBLIC- not working?
Previous:From: Brian HurtDate: 2006-07-31 20:00:30
Subject: precompiling regular expressions in plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group