Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> Hi, is there a way to enter integer data by their HEX
> representation??
I'm not sure that this is SQL-spec, but at least as of 7.3, you can
coerce a bitstring literal to int, so:
z=# select x'0f';
?column?
----------
00001111
(1 row)
z=# select x'0f'::int4;
int4
------
15
(1 row)
Looks like it works for int8 as well.
regards, tom lane