Re: Problem with a Pettern Matching Check

On Mon, 15 Aug 2005 18:37:52 -0400
"Dmitri Bichko" <dbichko(at)aveopharma(dot)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