Hi, You can use to_hex() function to convert integer to hexa number. I have tried with a small example.
create table testing( id int4 , sHex varchar( 20 ) ) insert into testing( id ) values( 204678 ); insert into testing( id ) values( 2076876 ); update testing set sHex = ( cast( to_hex( id ) as varchar( 20 ) ) ) select * from testing Id | shex -------|------ 204678 | 31f86 2076876| 1fb0cc Regards, R.Muralidharan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fernando Grijalba Sent: Thursday, June 02, 2005 2:12 AM To: pgsql-sql@postgresql.org Subject: [SQL] Convert int to hex I want to be able to change an int4 from a sequence and store it as varchar in the database as a hex number. Is this possible? Thank you, Fernando ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
