Postgres Pro
Downloads
Home   >   mailing lists

Help on Converting data types - Mailing list pgsql-sql

From Marcio Macedo
Subject Help on Converting data types
Date
Msg-id 359A0892.D0396206@conectiva.com.br
Whole thread Raw
List pgsql-sql
Tree view 
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: Aleksey Dashevsky
Date:
Subject: Re: [SQL] Rowid
Next
From: "Cristóvão Barbosa Braga Dalla Costa"
Date:
Subject: ...