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 Hurt||Date: 2006-08-01 19:06:49|
|Subject: GRANT role TO PUBLIC- not working?|
|Previous:||From: Brian Hurt||Date: 2006-07-31 20:00:30|
|Subject: precompiling regular expressions in plpgsql|