Re: Data TYPE Creation - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Data TYPE Creation
Date
Msg-id 20030317132932.GB19079@wolff.to
Whole thread Raw
In response to Data TYPE Creation  ("Guillaume Houssay" <ghoussay@noos.fr>)
List pgsql-general
On Sun, Mar 16, 2003 at 23:39:22 +0100,
  Guillaume Houssay <ghoussay@noos.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.

pgsql-general by date:

Previous
From: Joshua Moore-Oliva
Date:
Subject: Re: copying between Postgres databases
Next
From: Bruno Wolff III
Date:
Subject: Re: Data TYPE Creation