Received: from cicero2.cybercity.dk (cicero2.cybercity.dk [212.242.40.53]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3GG73u27506 for ; Mon, 16 Apr 2001 12:07:04 -0400 (EDT) (envelope-from poulc@cs.auc.dk) Received: from usr04.cybercity.dk (usr04.cybercity.dk [212.242.40.36]) by cicero2.cybercity.dk (Postfix) with ESMTP id 8F394FFF1D; Mon, 16 Apr 2001 18:06:57 +0200 (CEST) Received: from cs.auc.dk (port56.ds1-aboes.adsl.cybercity.dk [212.242.226.121]) by usr04.cybercity.dk (8.11.2/8.11.0) with ESMTP id f3GG6mM82175; Mon, 16 Apr 2001 18:06:49 +0200 (CEST) (envelope-from poulc@cs.auc.dk) Message-ID: <3ADB1894.21BF68A2@cs.auc.dk> Date: Mon, 16 Apr 2001 18:06:44 +0200 From: "Poul L. Christiansen" X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: cbell Cc: pgsql-sql@postgresql.org Subject: Re: Range of Serial values References: <3ADB0FEF.12951EE1@lighthouseasp.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/251 X-Sequence-Number: 2601 Yes, there is. When you create a serial column a sequence is created, which does the counting. You can create a serial column, drop the associated sequence and create a new one with the command: "CREATE SEQUENCE seqname START 1000". See also "\h CREATE SEQUENCE". HTH, Poul L. Christansen cbell wrote: > > Hello everyone, > > when creating a serial column, is there a way to specify which number it > will start counting from? For example, if you wanted all Serial ID's to > start at 1000 and count up from there, with no numbers below that. > > Thanks, > Chris. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html