Received: from perninha.conectiva.com.br (perninha.conectiva.com.br [200.250.241.1]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA18744 for ; Wed, 1 Jul 1998 09:02:19 -0400 (EDT) Received: from conectiva.com.br (presuntinho.conectiva.com.br [200.250.241.13]) by perninha.conectiva.com.br (8.9.0/8.9.0) with ESMTP id HAA08751 for ; Wed, 1 Jul 1998 07:00:25 -0300 Sender: marciom@perninha.conectiva.com.br Message-ID: <359A0892.D0396206@conectiva.com.br> Date: Wed, 01 Jul 1998 09:59:47 +0000 From: Marcio Macedo X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Help on Converting data types Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi... I need to convert a char field to a integer filed in order to increase the value: something like this COD_Customer char(6) ex.: 410023 (suposing that this is the last code added) So, when I insert a new customer I need the code 410024.... and the next will 410025... etc... How can I do that ?