Re: Regex bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Regex bug
Date
Msg-id 20907.1091814246@sss.pgh.pa.us
Whole thread Raw
In response to Regex bug  (David Fetter <david@fetter.org>)
List pgsql-bugs
David Fetter <david@fetter.org> 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 characters from bytes :)

> Cheers,
> D (feeling a little sheepish. again.)

It occurs to me that a case could be made for having text_in throw an
error if it sees '\000'.  I cannot really see that there's any benefit
to the current behavior of (effectively) silently truncating the string.

Comments?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regex bug
Next
From: David Fetter
Date:
Subject: Re: Regex bug