Обсуждение: cast hex to int in plpgsql

Поиск

Список

Период

Сортировка

cast hex to int in plpgsql

От

"Janek Sendrowski"

Дата:

31 декабря 2013 г., 22:28:53

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

Re: cast hex to int in plpgsql

От

Pavel Stehule

Дата:

31 декабря 2013 г., 22:36:09

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

Re: cast hex to int in plpgsql

От

"Janek Sendrowski"

Дата:

01 января 2014 г., 00:55:26

Thanks!
That's what I'm searching for.
 
Janek

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: cast hex to int in plpgsql

cast hex to int in plpgsql

Re: cast hex to int in plpgsql

Re: cast hex to int in plpgsql