Am Dienstag, 21. Juni 2005 12:01 schrieben Sie:
> hi,in a table with a serial datatype, how do i get the sequence to start at
> a specific number like 100000?
Use START in the create sequence statement.
#
create sequence seq_xeingang increment 1 start 1000;
;
CREATE TABLE xeingang
( id integer default nextval('seq_xeingang'), buch char not null, eingdt date not null, jnr
integer not null, grp integer, code integer not null
);
my best regards..
Stefan