Jeremy Drake <pgsql@jdrake.com> writes:
> On several occasions I have wanted to input integers in hexadecimal rather
> than in decimal in PostgreSQL. I notice that there is a to_hex function,
> but there is not (AFAIK) a way to provide an integer in hexadecimal.
regression=# select x'abcd'::int;int4
-------43981
(1 row)
regards, tom lane