hello,

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...

Bye, Chris.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

I've found it myself

select x'FFFF'::int; -- this works

Bye, Chris.



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings