Re: [GENERAL] auto-increment field : in a simple way

st(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

Re: [GENERAL] Auto Adjust Age

g with a view that calls > date_trunc('year', now() - dob). > > If you must store the age then you have to run a daily batch to make the > bulk update. Theres also the age() function SELECT age(dob); Should give you age - 31 years 5 m