Re: [GENERAL] help with serial type

2001-04-26 Thread Peter Eisentraut
Jason writes: > Hi , I'm a postgreSQL newbie. I have a table called "atable" that has > the columns: > title varchar(20) > name varchar(20) > id serial > if I do: > INSERT INTO TABLE atable VALUES('SQL1','Jason') > the 'id' gets updated with a new number automatically. I then later > added a n

[GENERAL] help with serial type

2001-04-26 Thread Jason
Hi , I'm a postgreSQL newbie. I have a table called "atable" that has the columns: title varchar(20) name varchar(20) id serial if I do: INSERT INTO TABLE atable VALUES('SQL1','Jason') the 'id' gets updated with a new number automatically. I then later added a new column called 'date'. Now if