Re: Writing regex in PL's
От | Scott Marlowe |
---|---|
Тема | Re: Writing regex in PL's |
Дата | |
Msg-id | 1091914998.27166.265.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Writing regex in PL's (David Garamond <lists@zara.6.isreserved.com>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: