Re: [SQL] What do I do with this error?

[Tom Lane]

"Josh Berkus" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster