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
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
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