Achilleus Mantzios <[EMAIL PROTECTED]> writes:
> 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.
No, I think you could do it with a placeholder if you wanted. The
secret is the (poorly documented) external syntax for a hex bit string:
regression=# select 'xBEEF'::bit varying;
varbit
------------------
1011111011101111
(1 row)
So it should work to do "SELECT int4($1::bit varying)" and then pass
'xBEEF' as the string value for the parameter.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
