Re: precompiling regular expressions in plpgsql

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

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