On Mon, 15 Aug 2005 18:37:52 -0400 "Dmitri Bichko" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
