Received: from odysseus2.dohle.com (odysseus2.dohle.com [194.127.185.20]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBLAic697012 for ; Thu, 21 Dec 2000 05:44:38 -0500 (EST) (envelope-from vpaul@dohle.com) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus2.dohle.com (8.9.3/8.9.3) with SMTP id LAA21086; Thu, 21 Dec 2000 11:44:25 +0100 Received: from wpaul.dohle.com by majestix.dohle.com id aa08087; 21 Dec 100 11:44 CET Message-ID: <3A41E325.C8E5D7EF@dohle.com> Date: Thu, 21 Dec 2000 12:01:57 +0100 From: Volker Paul Organization: Dohle Handelsgruppe Systemberatung GmbH X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: Kaare Rasmussen CC: PostgreSQL-SQL Subject: Re: Invoice number References: <00122111100003.25042@bering> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/247 X-Sequence-Number: 584 Hi, > I'm wondering how people creates guaranteed sequential numbers - in my case > for invoice numbers. See the PostgreSQL book p. 85 and 250, and the online doc about serials: CREATE TABLE person ( id SERIAL, name TEXT ); Volker Paul