On Tuesday 21 June 2005 13:01, you wrote:
> hi,
> in a table with a serial datatype, how do i get the sequence to start
> at a specific number like 100000?
ALTER SEQUENCE sequence_name RESTART WITH 100000;
--
________________________________________________________
Krasimir Dimitrov
IT Department
AII Data Processing Ltd.,
16 Ivan Vazov Str,
Sofia 1000,
Bulgaria
Phone: +359 2 9376 352
E-mail: kr(at)aiidatapro(dot)com
http://www.see-news.com