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

From Jean-Luc Lachance
Subject Re: Bug in concat operator for Char? -- More Info
Date
Msg-id 40FE63AA.5020501@sympatico.ca
Whole thread Raw
In response to Re: Bug in concat operator for Char? -- More Info  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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 <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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

pgsql-bugs by date:

Previous
From: "Junior - Cotrijui"
Date:
Subject: Problem: Sequence X Rule Reference!
Next
From: Stephan Szabo
Date:
Subject: Re: Bug in concat operator for Char? -- More Info