On Mon, 15 Aug 2005 18:37:52 -0400
"Dmitri Bichko" <dbichko@aveopharma.com> wrote:
> I'm guessing it's because char gets padded with spaces to the
> specified length.
argh. Thank you.
> Any reason you are using char(3) instead of varchar(3)?
The numbers will have 2 or 3 digits so I tried to save some space :)
> And why are you storing numbers as a string, anyway? If you defined
> the column as a numeric type, postgres will tell you if you try to
> insert something non-numeric.
Correct. I will not let the values to be used together with
sum/avg/+/...
>
> Dmitri
>
--
Regards
Sebastian Siewior