trailing spaces - Mailing list pgsql-general

From Alejandro Fernandez
Subject trailing spaces
Date
Msg-id 3B011D1F.733D5F70@nin.cx
Whole thread Raw
Responses Re: trailing spaces
List pgsql-general
Hi,

I have a table with a field created as char(400). For some reason, when
I insert information into this, trailing spaces are automatically added
so that select char_length(fieldname) always gives 400.

How can I amend this table column so that I don't have to use "select
trim(trailing from fieldname);" to get a well formatted result?

Thanks

Ale
--
Alejandro Fernandez Bscp 5 Caledonian University
0790 541 8809 - ale@nin.cx

pgsql-general by date:

Previous
From: "Gyozo Papp"
Date:
Subject: Re: index ops for _int4 and trees?
Next
From: Justin Clift
Date:
Subject: Re: trailing spaces