Re: What do I do with this error?

"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