Re: character and text comparison - Mailing list pgsql-bugs

Jacek Rembisz <jr178783@zodiac.mimuw.edu.pl> writes:
> When I run  SELECT ' '::character = ' '::text;
> on PostgreSQL 7.4 the result is `false'
> while on 7.3 and 7.2 instalations result is `true'

> Is this an intentional change?

Yes.

We now strip trailing blanks when converting a char(n) value to text.

            regards, tom lane