Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id BAA35659E1A
	for <pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Wed, 13 Jan 2010 19:07:30 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 92743-01-10
	for <pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Wed, 13 Jan 2010 23:07:14 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.24])
	by mail.postgresql.org (Postfix) with ESMTP id 81D596337C5
	for <pgsql-bugs@postgresql.org>; Wed, 13 Jan 2010 18:20:18 -0400 (AST)
Received: by ey-out-2122.google.com with SMTP id 9so251604eyd.3
	for <pgsql-bugs@postgresql.org>; Wed, 13 Jan 2010 14:20:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=hbHIArgcb/qMzl3zKsEn3znoSNGkFwnvBk6iBfnpxL4=;
	b=hV0frpnnMIK+dfyPjj89fU5CPCYhwB1f1wrAQSPICsPpXTvMWdhLBHxJZe6ml0REXY
	3p7pHKf9jjSb1vi9/IVFgPjb2oDXTrQzjPdCackNpzTVD1ADuY0ww3jkKhEet3tjXFJW
	rHZ7tBx7nCd22MoAFR55kwasEGTczKWmags20=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=gPvF+V+q4PQEzoeuOIQaAH+3Tfw7/4xbA2jvh4SiV1FPdMijqYjKnQexGDiu0f26ab
	WGlw/c0y3iHw1sqdls54vP0UnFAT2AMRuN+kzccORTwQj6qEoaKOvpNpOTX9RNMz6VRb
	WTqR/RxtzP1lVHxzhv3Q/5w2K7rP2iro+avqQ=
MIME-Version: 1.0
Received: by 10.216.85.9 with SMTP id t9mr1156182wee.79.1263421216257;
 Wed, 13
	Jan 2010 14:20:16 -0800 (PST)
In-Reply-To: <4B4DAC9C020000250002E445@gw.wicourts.gov>
References: <65d71e1c1001130102j5f46299cm87477efcfd0c5a51@mail.gmail.com>
	<10878.1263396935@sss.pgh.pa.us>
	<4B4D9A0F020000250002E432@gw.wicourts.gov>
	<14774.1263402847@sss.pgh.pa.us>
	<4B4DAC9C020000250002E445@gw.wicourts.gov>
Date: Thu, 14 Jan 2010 08:20:16 +1000
Message-ID: <65d71e1c1001131420l532f18e5o82521b2b888c7d9d@mail.gmail.com>
Subject: Re: Substring auto trim
From: "Charles O'Farrell" <charleso@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@postgresql.org
Content-Type: multipart/alternative; boundary=0016e6d778afcbf621047d132c38
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201001/132
X-Sequence-Number: 25636

--0016e6d778afcbf621047d132c38
Content-Type: text/plain; charset=ISO-8859-1

On Thu, Jan 14, 2010 at 3:21 AM, Kevin Grittner <Kevin.Grittner@wicourts.gov
> wrote:

>
> 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....
>
>
Many thanks for the quick and detailed responses. Looks like we'll have to
stick with that work around for now.

Part of the problem for us re: varchars is that we are using Cobol where
trailing spaces are significant and litter all our data and queries.

Thanks again.

Charles

--0016e6d778afcbf621047d132c38
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"im">On Thu, Jan 14, 2010 at 3:21 AM, Kevin Grittner <span dir=
=3D"ltr">&lt;<a href=3D"mailto:Kevin.Grittner@wicourts.gov" target=3D"_blan=
k">Kevin.Grittner@wicourts.gov</a>&gt;</span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin=
: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<br>
I&#39;m inclined to agree with you, but it does present a barrier to<br>
those migrating. =A0Are there any &quot;migration considerations&quot; docu=
ments<br>
where we should mention this? =A0Standards compliance notes in the<br>
docs? =A0Some form of this question seems to be asked frequently....<br>
<font color=3D"#888888"><br></font></blockquote></div><br>Many thanks for t=
he quick and detailed responses. Looks like we&#39;ll have to stick with th=
at work around for now.<br><br>Part
of the problem for us re: varchars is that we are using Cobol where
trailing spaces are significant and litter all our data and queries.<br>
<br>Thanks again.<br><br>Charles

--0016e6d778afcbf621047d132c38--