Received: from web1.lighthouseasp.com (gw.lighthouseasp.com [216.191.176.98] (may be forged)) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3GFbnu22812 for ; Mon, 16 Apr 2001 11:37:49 -0400 (EDT) (envelope-from cbell@lighthouseasp.com) Received: from lighthouseasp.com ([216.191.139.105]) by web1.lighthouseasp.com (8.9.3/8.8.7) with ESMTP id KAA17216 for ; Mon, 16 Apr 2001 10:32:30 -0400 Message-ID: <3ADB0FEF.12951EE1@lighthouseasp.com> Date: Mon, 16 Apr 2001 11:29:51 -0400 From: cbell Organization: Lighthouse ASP X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Range of Serial values Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/250 X-Sequence-Number: 2600 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.