X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C8AB6528B4 for ; Tue, 21 Jun 2005 13:33:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50408-01 for ; Tue, 21 Jun 2005 16:33:42 +0000 (GMT) Received: from 208091.vserver.de (nirs.de [62.75.208.91]) by svr1.postgresql.org (Postfix) with ESMTP id 7A2DF528B2 for ; Tue, 21 Jun 2005 13:33:39 -0300 (ADT) Received: from becker.local (p54AD0D49.dip0.t-ipconnect.de [84.173.13.73]) (authenticated bits=0) by 208091.vserver.de (8.12.8/8.12.8) with ESMTP id j5LGXUw5003272 for ; Tue, 21 Jun 2005 18:33:31 +0200 From: Stefan Becker To: PostgreSQL SQL Subject: Re: customising serial type Date: Tue, 21 Jun 2005 18:34:39 +0200 User-Agent: KMail/1.6.2 References: <200506211531.28871.lawgon@thenilgiris.com> In-Reply-To: <200506211531.28871.lawgon@thenilgiris.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200506211834.39833.stefan@yukonho.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/328 X-Sequence-Number: 21929 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