Re: [BUGS] Regex bug

2004-08-06 Thread David Fetter
On Fri, Aug 06, 2004 at 01:32:32PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > Here's a symptom as reported by John Hansen aka applejack: > > > SELECT 'r'||'\000\125'||'hello' ~ '^.hello' AS "OMG"; > > This is not a regex bug: it has to do with the fact that we don't > s

Re: [BUGS] Regex bug

2004-08-06 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > On Fri, Aug 06, 2004 at 01:32:32PM -0400, Tom Lane wrote: >> regression=# select length ('\000\125'); >> length >> >> 0 >> (1 row) > Ah, right. John was testing his unicode patch, so there must be some > magick underneath that distinguishes char

Re: [BUGS] Regex bug

2004-08-06 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > Here's a symptom as reported by John Hansen aka applejack: > SELECT 'r'||'\000\125'||'hello' ~ '^.hello' AS "OMG"; This is not a regex bug: it has to do with the fact that we don't support embedded nulls in text values. This may enlighten you a bit as t