Postgres Pro
Downloads
Home   >   mailing lists

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  (Jean-Luc Lachance <jllachan@sympatico.ca>)
Re: Bug in concat operator for Char? -- More Info  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
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!