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      [EMAIL PROTECTED]
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to