Re: auto-increment field : in a simple way
| От | JC de Villa |
|---|---|
| Тема | Re: auto-increment field : in a simple way |
| Дата | |
| Msg-id | CAOvw+Nb89kY0saNH8EUv6ZEay6e7Q0bg7_OdKz7WYqqaVeiK7w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: auto-increment field : in a simple way (Vineet Deodhar <vineet.deodhar@gmail.com>) |
| Список | pgsql-general |
On Thu, Oct 11, 2012 at 5:11 PM, Vineet Deodhar <vineet.deodhar@gmail.com> wrote:
On Thu, Oct 11, 2012 at 12:56 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:Can't you just add this to your create table:, check (colname>0 and colname < 32768));
CREATE TABLE tablename (
colname SERIAL
);
With this constraint, whether the storage space requirement would reduce?
OR
Is it just for validation of data?
--- Vineet
Well, there's smallserial when creating tables...
create table test(a smallserial);
NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for serial column "test.a"
CREATE TABLE
Table "public.test"
Column | Type | Modifiers
--------+----------+--------------------------------------------------
a | smallint | not null default nextval('test_a_seq'::regclass)
JC de Villa
В списке pgsql-general по дате отправления: