HK wrote:
> Is there any function available in pgsql to display an integer value as
> a hex value and vice versa.
>
This works in 7.3, but not earlier:
test=# select to_hex(15678);
to_hex
--------
3d3e
(1 row)
This might also work in 7.2, but I'm not too sure, and I don't have a
7.2.x installation to test with:
test=# select x'3d3e'::int;
int4
-------
15678
(1 row)
HTH,
Joe