Help on Converting data types - Mailing list pgsql-sql

From Marcio Macedo
Subject Help on Converting data types
Date
Msg-id 359A24D4.31191C75@conectiva.com.br
Whole thread Raw
List pgsql-sql

--
____________________________
Marcio Macedo
marciom@conectiva.com.br
Conectiva Internet Solutions
It's Red Hat Linux !!!


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 ?




pgsql-sql by date:

Previous
From: "Cristóvão Barbosa Braga Dalla Costa"
Date:
Subject: ...
Next
From: Brian
Date:
Subject: Re: [SQL] gmake not found