Re: parsing a string with a hexadecimal notation - Mailing list pgsql-sql

Achilleus Mantzios <achill@matrix.gatewaynet.com> 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