X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 36A33D1B1B6; Fri, 21 May 2004 11:27:28 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 73776-10; Fri, 21 May 2004 11:27:11 -0300 (ADT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 56C7DD1B1DC; Fri, 21 May 2004 11:27:07 -0300 (ADT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 4C5DB35530; Fri, 21 May 2004 07:27:12 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 4AD7E35391; Fri, 21 May 2004 07:27:12 -0700 (PDT)
Date: Fri, 21 May 2004 07:27:12 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: rong.xie@stud.tu-muenchen.de
Cc: pgsql-docs@postgresql.org, pgsql-general@postgresql.org
Subject: Re: PostgreSQL delete the blank in the end of the String
In-Reply-To: <47181.138.245.10.1.1084894054.squirrel@webmail.lrz-muenchen.de>
Message-ID: <20040521072347.Q46005@megazone.bigpanda.com>
References: <47181.138.245.10.1.1084894054.squirrel@webmail.lrz-muenchen.de>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/672
X-Sequence-Number: 61106

On Tue, 18 May 2004 rong.xie@stud.tu-muenchen.de wrote:

> hello,
>
> my Name is Rong. I am student at TU-Munich. I have some questions for
> Postgresql7.2  under SuSe Linux.
> Postgresql7.2  under SuSe Linux8.0.
> I use PostgreSQL7.2 with PGAdminII1.4.2 under Windows2000.

Note, 7.2 is fairly old (and I hope you really mean 7.2.x for the last x
in the set of 7.2 versions)

> I insert a String from Teleform6.0 of Cardiff through ODBC in table of
> PostgreSQL.
> There should be some blank in the End of the String. e.g: "data
>      "
> But there ist no blank in the end of the String in the table. e.g: "data"
> It means, that PostgreSQL delete the blank in the end of the String
> automatically.
> But I need the blank in the end of the String.

What type are you inserting into?  Can you give a self contained set of
table creation and inserts to show the problem?