Received: from hawk.mail.pas.earthlink.net (hawk.mail.pas.earthlink.net [207.217.120.22]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4F1XHA86090 for ; Mon, 14 May 2001 21:33:17 -0400 (EDT) (envelope-from mdavis@sevainc.com) Received: from SALLY (cpe-66-1-238-71.co.sprintbbd.net [66.1.238.71]) by hawk.mail.pas.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id SAA27752; Mon, 14 May 2001 18:33:13 -0700 (PDT) Received: by localhost with Microsoft MAPI; Mon, 14 May 2001 19:33:07 -0600 Message-ID: <01C0DCAC.B3BB8330.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Sylte'" , "pgsql-sql@postgresql.org" Subject: RE: Auto incrementing an integer Date: Mon, 14 May 2001 19:33:06 -0600 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/138 X-Sequence-Number: 2955 Try the serial data type or add "DEFAULT nextval('Invoice_s')" to the column definition where Invoice_s is the name of a sequence that you have created. Hope this helps, Michael -----Original Message----- From: Sylte [SMTP:Sylte_@hotmail.com] Sent: Monday, May 14, 2001 7:02 AM To: pgsql-sql@postgresql.org Subject: Auto incrementing an integer How do I construct a datatype that autoincrement in postgreSQL? Thanks Sylte ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)