Re: Convert int to hex

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: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Fernando Grijalba
Sent: Thursday, June 02, 2005 2:12 AM
To: pgsql-sql(at)postgresql(dot)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