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@nin.cx
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.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