On 10/11/2012 05:11 PM, Vineet Deodhar wrote:
On Thu, Oct 11, 2012 at 12:56 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx <mailto: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?
It's purely validation and has no effect on storage size. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
