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
