converting to hex

[Jamie Deppeler <jamie@xxxxxxxxxxxxxxx>]

Hi,

I am trying to write a function that will allow a postgres to convert a 
text string into a hex value but there doesnt seem a function to do it, 
only one i could find is to_hex(number) example of what i have done is

  update table1
  Set field2 = encode((select md5('field1')),'hex')
  where new."primary" = "primary";

any help would be greatfully received



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match