Received: from hanwoolbbs.com (root@hanwool.hanmi.net [207.106.21.13]) by hub.org (8.8.8/8.7.5) with ESMTP id CAA13653 for ; Wed, 15 Jul 1998 02:35:08 -0400 (EDT) Received: from pinga.cyberix.com (max2-ppp-9.cyberix.com [207.8.199.73]) by hanwoolbbs.com (8.8.5/8.8.5) with SMTP id CAA22090; Wed, 15 Jul 1998 02:43:15 -0400 From: "Sejin Oh" To: "=?euc-kr?B?udq5zLfm?=" , Subject: Re: [SQL] Finding strings inside a field... Date: Wed, 15 Jul 1998 02:34:13 -0400 Message-ID: <01bdafba$94ebc860$0201a8c0@pinga.cyberix.com> MIME-Version: 1.0 Content-Type: text/plain; charset="euc-kr" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 create sequence table. and use nextval('sequence_name') when inserting. eg: create sequence autocounter; create table customer (customerid int4 not null, name varchar(50) ); insert into customer values(nextval('autocounter),'Ronaldo'); or create sequence autocounter; create table customer (customerid int4 DEFAULT nextval('autocounter') not null, name varchar(50) ); when you INSERT, just ignore customerid field. ps: man create_sequence hope this helped. :) -----원본 메시지----- 보낸 사람: 박미룡 받는 사람: pgsql-sql@postgreSQL.org 날짜: Tuesday, July 14, 1998 9:48 PM 제목: Re: [SQL] Finding strings inside a field... >How can i make the field auto incremental ? > >It is in the mysql, but That's not in pgsql. > >How can I ? > >Please give me a info. >Thank you