Re: Bug in concat operator for Char? -- More Info - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in concat operator for Char? -- More Info
Date
Msg-id 4633.1090389336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in concat operator for Char? -- More Info  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Bug in concat operator for Char? -- More Info
Re: Bug in concat operator for Char? -- More Info
List pgsql-bugs
Josh Berkus <josh@agliodbs.com> writes:
> Are these changes intentional,

Yes.  We've been moving more and more steadily towards the notion that
trailing spaces in char(n) values are insignificant noise.  If you think
that trailing spaces are significant, you shouldn't be using char(n)
to store them.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SELECT DISTINCT on boxes
Next
From: "Junior - Cotrijui"
Date:
Subject: Problem: Sequence X Rule Reference!