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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco