Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group