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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, glenniii(at)mail(dot)utexas(dot)edu
Subject: Re: Bug in concat operator for Char? -- More Info
Date: 2004-07-21 05:55:36
Message-ID: 4633.1090389336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Junior - Cotrijui 2004-07-21 12:35:27 Problem: Sequence X Rule Reference!
Previous Message Bruce Momjian 2004-07-20 19:51:58 Re: SELECT DISTINCT on boxes