Received: from mail04.edsamail.com.ph ([203.177.1.29]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f022OtL19261 for ; Mon, 1 Jan 2001 21:24:55 -0500 (EST) (envelope-from macky@edsamail.com) Received: (qmail 19913 invoked from network); 2 Jan 2001 02:26:32 -0000 Received: from mail01.edsamail.com.ph (210.16.71.2) by mail04.edsamail.com.ph with SMTP; 2 Jan 2001 02:26:32 -0000 Received: (qmail 24579 invoked from network); 2 Jan 2001 02:24:26 -0000 Received: from unknown (HELO macky) (210.16.70.2) by mail01.edsamail.com.ph with SMTP; 2 Jan 2001 02:24:26 -0000 Message-ID: <003701c07462$fb451700$5764a8c0@edsamail.com> From: "Macky" To: "Postgresql-Sql" Subject: AUTOINCREMENT--help Date: Tue, 2 Jan 2001 10:23:23 +0800 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.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200101/7 X-Sequence-Number: 668 Is there a function in SQL that does autoincrementing... eg. CREATE TABLE (name varchar(40),num_id int); wherein num_id starts with 0 and then when ever I INSERT another record num_id goes 1 etc.... Thanks in advance............