Hello all,
I am trying to print some table values in hexadecimal.
I've seen in the docs that there is a function called 'hex'
but the following:

create table aa (a integer);
insert into aa values(10);
insert into aa values(11);
insert into aa values(12);
insert into aa values(13);
insert into aa values(14);
insert into aa values(15);
select hex(a) from aa;

results in: SQL error: no such function: hex

while:

select min(a) from aa;

results in the correct answer: 10

I've seen in the source code that the function hex does indeed exist and 
it is inserted into the built in function table together with the min 
and a load of other functions.

Before digging more into the sources, can you tell me if I am doing 
something stupid and how the function hex may be used?
Or at least if it is possible to print hexadecimal values at all.

Thanks all.
Mau.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to