hexdecimal constant in postgresql

From: Chris <list(at)1006(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: hexdecimal constant in postgresql
Date: 2004-07-26 12:16:18
Message-ID: 1090844178.5246.85.camel@dell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2004-07-26 13:45:07 Re: help with conversion functions
Previous Message Oliver Fromme 2004-07-26 09:52:23 Re: PyPgSQL help