hi,
i wrote my own hexadecimal datatype for postgresql. the input function
expects a char* and stores the data as an integer.
so i can do something like "SELECT 'ff'::hex;" to turn a string into my
datatype.
but i would like do be able doing the same with integers:
SELECT 255::hex;
... and then getting 'ff'.
do you know how i can realize that?
i already wrote a function 'to_hex' (int->hex) and 'to_int' (hex->int).
thanks,
moritz
--