On 10/11/2012 05:11 PM, Vineet Deodhar wrote:
> On Thu, Oct 11, 2012 at 12:56 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com
> <mailto:scott(dot)marlowe(at)gmail(dot)com>> wrote:
>
>
> Can't you just add this to your create table:
>
>
> CREATE TABLE tablename (
> colname SERIAL
> , check (colname>0 and colname < 32768));
> );
>
>
>
> With this constraint, whether the storage space requirement would reduce?
> OR
> Is it just for validation of data?
It's purely validation and has no effect on storage size.
--
Craig Ringer