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 <jane...@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 >
