Re: Hex Integer Input

On Fri, 7 Mar 2003, Tom Lane wrote:

> Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> > Hi, is there a way to enter integer data by their HEX
> > representation??
>
> I'm not sure that this is SQL-spec, but at least as of 7.3, you can
> coerce a bitstring literal to int, so:
>
> z=# select x'0f';
> ?column?
> ----------
> 00001111
> (1 row)
>
> z=# select x'0f'::int4;
> int4
> ------
> 15
> (1 row)

Thanx.

>
> Looks like it works for int8 as well.
>
> regards, tom lane
>

--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr