saqibrafique wrote > hi guys, > I am trying to convert a simple char value to HEX but I am getting Error. > * > MyTable: * > > CREATE TABLE mytable (from_ip CHAR(20), to_ip CHAR(20)); * > I have below values in the Table: * > > > fm_db_Server1=# select * from operator; > from_ip | to_ip > --------------------+---------------------- > 202.153.087.128 | 202.153.087.159 > 196.192.015.000 | 196.192.015.063 > (2 rows) > > > I am trying to extract the 1st part of the IP and convert to the HEX as > below: > > > fm_db_Server1=# * > select to_hex(to_number(substr(from_ip, 1, 3), '999')) as price from > operator; * > / > ERROR: function to_hex(numeric) does not exist > LINE 1: select to_hex(to_number(substr(from_ip, 1, 3), '999')) as p... > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. / > > > > I am not able to figure it out what is wrong here. Can Any body point out > what is wrong here. > Thanks is advance. The error says that the function to_hex(numeric) does not exist. Looking at the documentation the only to_hex function I found requires either integer or bigint input. Since numeric can be cast to integer/bigint the solution is simple. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Conversion-from-CHAR-HEX-tp5805115p5805127.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
