Jeremy Drake <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
