Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group