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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group