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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Laurent HERVE" <laurent-herve(at)club-internet(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1783: A function using char variables does not behave the same way between 7.4 and 8.0
Date: 2005-07-24 17:32:52
Message-ID: 21590.1122226372@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Laurent HERVE" <laurent-herve(at)club-internet(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Giacomo G 2005-07-25 02:03:54 BUG #1784: "adding missing FROM-clause" when not needed
Previous Message Laurent HERVE 2005-07-24 15:13:11 BUG #1783: A function using char variables does not behave the same way between 7.4 and 8.0