Writing regex in PL's

[David Garamond]

Is there anyone on this list who has preferred to use regexes from PL's
(e.g. plperl, plruby) in CHECK constraints or other places instead of
the flavor provided by Postgres? Do you find your approach satisfying?
Do you also do things like cache the pattern so you don't have to
compile the regex on every function invocation?

I'm also about to choose this route, mainly because I want to separate
the patterns into a Ruby module and would rather have one regex flavor
(and I can never remember all that POSIX stuffs anyway :-).

--
dave
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Scott Marlowe]

On Sat, 2004-08-07 at 14:40, David Garamond wrote:

Is there anyone on this list who has preferred to use regexes from PL's
(e.g. plperl, plruby) in CHECK constraints or other places instead of
the flavor provided by Postgres? Do you find your approach satisfying?
Do you also do things like cache the pattern so you don't have to
compile the regex on every function invocation?

I'm also about to choose this route, mainly because I want to separate
the patterns into a Ruby module and would rather have one regex flavor
(and I can never remember all that POSIX stuffs anyway :-).

I've never used plperl for regex, and I'm pretty comfy with posix regex,
as long as it's simple. Let's face it, perl regex is king for a reason,
and it ain't cause they're easy to read.

Now, SQL regex, that gives me a headache.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)