On Sun, 20 May 2007, madhtr wrote:
> How do use hex numbers in psql? I.E.
>
> instead of:
> select 16
> I want to do
> select 0x10
>
See 4.1.2.3: "SELECT x'1FF'::int"
http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
Kris Jurka