Re: Hex Integer Input - Mailing list pgsql-sql

Achilleus Mantzios <achill@matrix.gatewaynet.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