Jeremy Drake <pgsql(at)jdrake(dot)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