Re: [SQL] Storing/sorting hex data in PostgreSQL

2009-07-21 Thread nha
Hello, On 20/07/09 21:59, JJ wrote : > [...] > I want to sort and query the database based on the > hex addresses [...] > How can I store hex values in PostgreSQL and sort and query them? > PostgreSQL (since version 8.3 and maybe older) sets string functions for encoding/decoding strings from/t

[SQL] Storing/sorting hex data in PostgreSQL

2009-07-20 Thread JJ
I am parsing a map file and storing the hi, mid and low byte values of symbol addresses in a comma separated value (.csv) file. I am then importing this data into a PostgreSQL database with the copy command. The problem is that I want to sort and query the database based on the hex addresses; fr