Re: char() datatype looses strings of all spaces - Mailing list pgsql-hackers

From Tom Lane
Subject Re: char() datatype looses strings of all spaces
Date
Msg-id 9284.1061098488@sss.pgh.pa.us
Whole thread Raw
In response to char() datatype looses strings of all spaces  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> I stumbled across this behavior today and it seems strange if not a bug:

ascii() is defined as ascii(text).  As of 7.4, bpchar->text conversion
strips trailing blanks, so what ascii() sees is a zero-length string.

Given that trailing blanks are insignificant in bpchar, I'm not sure I'd
call this a bug.  If we decide it is, we could work around it by
creating an ascii(bpchar) entry ... but what's the argument that says
insignificant trailing blanks must map to the same thing as significant
blanks?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Question with hashed IN
Next
From: Stephan Szabo
Date:
Subject: Re: char() datatype looses strings of all spaces