On Fri, 2 Mar 2007, Tom Lane wrote: > 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)
Hmm. I actually used the bit(N) type on a project quite some time ago, but it did not occur to me to use the bit string input syntax to input an integer. Well, I guess there is a way after all. So in the immortal words of Emily Litella, "Never mind." -- In an organization, each person rises to the level of his own incompetency -- The Peter Principle ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster