David Garamond <[EMAIL PROTECTED]> writes:
Is there a function like IS_VALID_REGEX() to check whether a pattern is valid (i.e. it compiles)? I'm storing a list of regex patterns in a table. It would be nice to be able to add a CHECK constraint to ensure that all the regexes are valid.
... CHECK (('' ~ pattern) IS NOT NULL) ...
Not exactly what I wanted, but close enough. Thanks!
However, what if only want to accept invalid regex patterns? Or what if invalid pattern should be converted to NULL automatically? I'd still vote for a function...
-- dave
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
