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 of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
