On 10/11/2012 05:11 PM, Vineet Deodhar wrote:
> On Thu, Oct 11, 2012 at 12:56 PM, Scott Marlowe <scott.marlowe@gmail.com
> <mailto:scott.marlowe@gmail.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
