[GENERAL] Hex numbers in psql

2007-05-20 Thread madhtr
hi group :) How do use hex numbers in psql? I.E. instead of: select 16 I want to do select 0x10 like in c++ I tried doing what this website said http://www.faqs.org/docs/ppbook/c12119.htm but it does not work TY :) ---(end of

Re: [GENERAL] Hex numbers in psql

2007-05-20 Thread Kris Jurka
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 ---(end