"Josh Berkus" <josh@agliodbs.com> writes:
> Never mind. It turns out that if you call try to feed a NULL to a
> regular expression (e.g. Client_name ~* NULL) you get:
> ERROR: regcomp failed with error empty (sub)expression
> Good to know. I had expected that regular expressions, like other
> operators, would return NULL if NULL was the pattern. Is this a bug?
Yes, I'd say so. 7.1 returns a NULL as expected ...
regards, tom lane