Re: [BUGS] regex (not) matching null string

2002-06-21 Thread Tom Lane
"David M. Kaplan" <[EMAIL PROTECTED]> writes: > I have found that !~ and !~* do not match the null string even when one > would expect them to. NULL strings won't match anything. I can't tell whether your row 3 is an empty string or a NULL --- but if it's a NULL, this behavior is not a bug. Tr

Re: [BUGS] regex (not) matching null string

2002-06-21 Thread Stephan Szabo
On Wed, 19 Jun 2002, David M. Kaplan wrote: > I have found that !~ and !~* do not match the null string even when one > would expect them to. I am not sure if this is how it is supposed to > work or if this is an error. If this is how it works, I can't figure > out where it is states in the doc

[BUGS] regex (not) matching null string

2002-06-21 Thread David M. Kaplan
I have found that !~ and !~* do not match the null string even when one would expect them to. I am not sure if this is how it is supposed to work or if this is an error. If this is how it works, I can't figure out where it is states in the documentation. Let me give an example. Suppose we h