Re: Regex bug

David Fetter <david(at)fetter(dot)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