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" <janek12@web.de>) |
| Ответы |
Re: cast hex to int in plpgsql
|
| Список | pgsql-general |
Hello
this transformation is implemented inside parser - so you can not use a parameters there. You can use a dynamic SQL trickhttp://postgres.cz/wiki/PostgreSQL_SQL_Tricks_II#Conversion_between_hex_and_dec_numbers
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 по дате отправления: