Re: trailing spaces

Hi Alenjandro,

You'll probably want to use the type "varchar(400)" instead of
"char(400)".

It doesn't pad it's contents with spaces.

:-)

Regards and best wishes,

Justin Clift

Alejandro Fernandez wrote:
>
> 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(at)nin(dot)cx
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi