> i was wondering how to specify hexadecimal constants in
> SQL in a way that postgresql understands.
> something like:
> select 0xFFFF; -- this doesn't work;
> I've googled for it and i've found it can be done with
> encode/decode involving a bytea type - but i'm under
> the impression there must be a more straightforward way...
I've found it myself :)
select x'FFFF'::int; -- this works
In response to
pgsql-novice by date
|Next:||From: Rafael Charnovscki||Date: 2004-07-27 13:33:45|
|Subject: Re: Varchar or integer primary key?|
|Previous:||From: Stephan Szabo||Date: 2004-07-27 04:49:58|
|Subject: Re: help with conversion functions|