Serial datatype

[kimi]

Hi.

I have a serial datatype for id. Each serial will begin with 1. Is it possible to begin it with let say 11 and then it will increment each time i insert a new data and how to do it?

Thanks.

[chriskl]

You're using Postgres? You can manipulate your sequence by using "select setval('sequence', 11);" to set it's value to 11.

Or, instead of using a serial type, create sequence with the properties that you want, then set the default of the column you create to be nextval('sequence');

Chirs