On Sun, Mar 16, 2003 at 23:39:22 +0100,
Guillaume Houssay <ghoussay(at)noos(dot)fr> wrote:
> I wonder if the following data type is available INT1 (I am using the last version of Postgresql).
> I will have about 90% of my database with numeric values of only 1 byte.
>
> If it does not exist (according to what I read this is the case), is there a way to use another type with the same result ?
You can use a constraint to limit the valid range of integers. Probably
using int2 with a constraint is the best answer for you.