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

Re: Substring auto trim

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Charles O'Farrell" <charleso(at)gmail(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Substring auto trim
Date: 2010-01-13 17:21:00
Message-ID: 4B4DAC9C020000250002E445@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
 
>> This looks like another situation where we're running into
>> trouble because of non-standard behavior when people might be
>> expecting something consistent with other products and the
>> explicit language in the standard.
> 
> If we were to change that so that 'ab  ' were implicitly typed as
> char(4), then we'd start getting bug reports from people
> complaining that "select 'ab' = 'ab  '" yields true.  I remain of
> the opinion that char(n) is so hopelessly brain-damaged that we
> should be very careful to NOT bring it into our mainstream
> behavior.
 
I'm inclined to agree with you, but it does present a barrier to
those migrating.  Are there any "migration considerations" documents
where we should mention this?  Standards compliance notes in the
docs?  Some form of this question seems to be asked frequently....
 
-Kevin

In response to

Responses

pgsql-bugs by date

Next:From: David E. WheelerDate: 2010-01-13 19:08:33
Subject: Termination When Switching between PL/Perl and PL/PerlU
Previous:From: Tom LaneDate: 2010-01-13 17:14:07
Subject: Re: Substring auto trim

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