Re: auto-increment field : in a simple way

[Vineet Deodhar <vineet.deodhar@xxxxxxxxx>]

On Thu, Oct 11, 2012 at 12:56 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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?

--- Vineet