Re: parsing a string with a hexadecimal notation

O KΦPFERL Robert έγραψε στις Feb 9, 2005 :

> I intend to retrieve an int value in an integer variable from a string with
> a hexadecimal notation of a number.
> Which function is appropriate to do
> i int4
> i = ???('BEAF')

You can do something like

foodb=# SELECT int4(X'FF'::bit varying);
int4
------
255
(1 row)

but i suspect you must prepare your statement out of sql.

E.g. in java:

String hex="FF";
st = con.prepareStatement("select int4(X'"+hex+"'::bit varying");

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
-Achilleus