On Fri, 7 Mar 2003, Joe Conway wrote:
> Achilleus Mantzios wrote:
> > Hi, is there a way to enter integer data by their HEX
> > representation??
> >
>
> Is this what you want?
>
> regression=# select x''::int4;
> int4
> ---
> 65535
> (1 row)
Sure. Thanx.
>
>
> Joe
>
--
==
On Fri, 7 Mar 2003, Tom Lane wrote:
> Achilleus Mantzios <[EMAIL PROTECTED]> 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
