cast hex to int in plpgsql - Mailing list pgsql-general

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