Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4TJwBE68755 for ; Tue, 29 May 2001 15:58:11 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4TJlCJ38731 for pgsql-sql@postgresql.org; Tue, 29 May 2001 15:47:12 -0400 (EDT) (envelope-from news) From: Vivek Khera X-Newsgroups: comp.databases.postgresql.sql Subject: Re: START for SERIAL type? Date: 29 May 2001 15:47:11 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 16 Message-ID: References: <3B11975D.2BBC3350@iexposure.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: scrappy@hub.org User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) To: pgsql-sql@postgresql.org X-Archive-Number: 200105/316 X-Sequence-Number: 3157 >>>>> "j" == jferry writes: j> When you create a SEQUENCE, you are allowed to specify a START. Is j> there a way to specify a START if you use a serial type in a CREATE j> TABLE statement? No. You do it after you create the table. The SERIAL type creates a sequence, so just use the sequence command setval() to set the starting value for the named sequence. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/