From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Charles O'Farrell <charleso@gmail.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: Substring auto trim
Date: Wed, 13 Jan 2010 11:21:00 -0600
Message-ID: <4B4DAC9C020000250002E445@gw.wicourts.gov> (raw)
In-Reply-To: <14774.1263402847@sss.pgh.pa.us>
References: <65d71e1c1001130102j5f46299cm87477efcfd0c5a51@mail.gmail.com>
<65d71e1c1001130102j5f46299cm87477efcfd0c5a51@mail.gmail.com>
<10878.1263396935@sss.pgh.pa.us>
<4B4D9A0F020000250002E432@gw.wicourts.gov>
<4B4D9A0F020000250002E432@gw.wicourts.gov>
<14774.1263402847@sss.pgh.pa.us>
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, tgl@sss.pgh.pa.us, charleso@gmail.com
Subject: Re: Substring auto trim
In-Reply-To: <4B4DAC9C020000250002E445@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox