Help on Converting data types

From: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Help on Converting data types
Date: 1998-07-01 09:59:47
Message-ID: 359A0892.D0396206@conectiva.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ?

Browse pgsql-sql by date

  From Date Subject
Next Message Sergei M. Suntsov 1998-07-01 10:37:45 Rowid
Previous Message Aleksey Dashevsky 1998-06-30 16:53:51 Re: [SQL] Where is the String Length function?