Received: from openmail.kick.com (adsl-63-205-173-34.dsl.snfc21.pacbell.net [63.205.173.34]) by hub.org (8.10.1/8.10.1) with ESMTP id e5FJAQI35823 for ; Thu, 15 Jun 2000 15:10:35 -0400 (EDT) Received: from planetblargh (adsl-63-205-173-36.dsl.snfc21.pacbell.net [63.205.173.36]) by openmail.kick.com (8.9.3/8.9.3) with SMTP id MAA04405; Thu, 15 Jun 2000 12:10:14 -0700 Message-ID: <00d801bfd6fd$41344dc0$0c64010a@kick.com> From: "Stephan Szabo" To: "Alex" Cc: References: <39457549.CEA07C63@ihug.com.au> <39459935.CCCEFDAA@ihug.com.au> <87hfaxkelm.fsf@ptdixon.globalnet.co.uk> <39487DD3.7F2BBAE1@ihug.com.au> Subject: Re: Re: Simple search question Date: Thu, 15 Jun 2000 12:09:39 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200006/181 > This brings me back to another unanswered question recently posted up,maybe > it is impossible... > I declared a new table with one of the types as serial (which is really just a > sort of macro I believe, which automates the creation of a few things for your > convenience), which initialises the last_value of the relation (the sequence > itself), as 1. Therefore, upon INSERTing my first row, the serial number began > at 1, next was 2, then 3, and so forth. > My question is, is it possible to alter the sequence last_value column, as > I need the serial number to begin from 1000? select setval(sequencename, value); should set the sequence as if value was the last value given out in the sequence.