Re: [BUGS] Bug in concat operator for Char? -- More Info

[Jean-Luc Lachance]

This means that there is no more difference between CHAR(N) and 
VARCHAR(N). To bad... '1 ' sould be different from '1'.

Tom Lane wrote:
Josh Berkus <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
               http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org