hex to decimal and back again

Поиск
Список
Период
Сортировка
От Peter Nixon
Тема hex to decimal and back again
Дата
Msg-id b5v5rb$cuj$1@news.hub.org
обсуждение исходный текст
Ответы Re: hex to decimal and back again  (Joe Conway <mail@joeconway.com>)
Список pgsql-general
Hi guys

I have some hex values which I am currently storing in varchar fields which
I would like to convert to decimal integers to make sorting and indexing
work correctly. I may need to convert them back to hex at some point for
display but this is not strictly necessary. I can seem to find the right
function to do this in postgres.

I can obviously do it in perl but thats not the best way.

Can someone give me pointers?

--

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc

В списке pgsql-general по дате отправления:

Предыдущее
От: Darren Ferguson
Дата:
Сообщение: Re: how to test whether postgres server is running?
Следующее
От: Tad Marko
Дата:
Сообщение: Re: Earth distance