Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.10.1/8.10.1) with ESMTP id e5F7Ab833440 for ; Thu, 15 Jun 2000 03:10:37 -0400 (EDT) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id DAA26434 for pgsql-sql@postgresql.org; Thu, 15 Jun 2000 03:10:12 -0400 (EDT) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f From: Alex X-Newsgroups: linux.postgres, comp.databases.postgresql.questions, comp.databases.postgresql.sql Subject: Re: Simple search question Date: Thu, 15 Jun 2000 16:55:15 +1000 Organization: billgates.org - opensource Win3.1 project Lines: 19 Message-ID: <39487DD3.7F2BBAE1@ihug.com.au> References: <39457549.CEA07C63@ihug.com.au> <39459935.CCCEFDAA@ihug.com.au> <87hfaxkelm.fsf@ptdixon.globalnet.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Server-Date: 15 Jun 2000 06:56:52 GMT X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200006/154 Hi, > I had the same problem but was using Java, not PHP (I guess that > whatever I can do in JDBC, you can do in PHP ;-)). > > SELECT last_value FROM ; 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? Thanks, Alex