Re: What do I do with this error?

Folks,
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?

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco