Re: BUG #1783: A function using char variables does not behave the same way between 7.4 and 8.0 - Mailing list pgsql-bugs

"Laurent HERVE" <laurent-herve@club-internet.fr> writes:
> I am upgrading a 7.4 database to PostgreSQL 8.0.
> During my tests, I found that the results of a function weren't like I
> expected to.
> I am using a 8.0.1 but I didn't find anything related to that problem on the
> release note for later versions.

This is intentional --- trailing spaces in char(N) data are now
considered insignificant in more contexts than before, including
concatenation.

            regards, tom lane