Re: cast hex to int in plpgsql

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: cast hex to int in plpgsql
Дата
Msg-id
CAFj8pRD_iWbaVed5Yw+F5BDW8BPsyHHXajfJFtkGG4c+Y+fpHg@mail.gmail.com
Ответ на
cast hex to int in plpgsql (Janek Sendrowski)
Список
Дерево обсуждения
cast hex to int in plpgsql "Janek Sendrowski" <janek12@web.de>
Re: cast hex to int in plpgsql Pavel Stehule <pavel.stehule@gmail.com>
Re: cast hex to int in plpgsql "Janek Sendrowski" <janek12@web.de>
Hello

this transformation is implemented inside parser - so you can not use a parameters there. You can use a dynamic SQL trick

http://postgres.cz/wiki/PostgreSQL_SQL_Tricks_II#Conversion_between_hex_and_dec_numbers

Regards

Pavel


2013/12/31 Janek Sendrowski <janek12@web.de>
Hi,

How can I realize the line?
v_res := cast(x'v_tmp' as bigint);

v_tmp is a text variable with hex digits.

this works:
v_res := cast(x'6de14a8b478ac' as bigint);

I think its about quoting

Janek


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: Adrian Klaver
Дата:
FAQ