Niall O'Reilly wrote:
> I've coded up a custom collation method, and am seeing
> what looks like strange behaviour. The method is
> intended to sort IPv4 addresses before IPv6 addresses,
> and IPv6 addresses before other text strings.
>
> select rowid, * from foo order by x collate ipaddress;
> 6|
> 5| ABCD
> 3|100A
> 2|127.0.0.1
> 4|128A
> 1|::1
Do these queries give the correct result?
select '100A' collate ipaddress < '127.0.0.1';
select '100A' collate ipaddress < ' ABCD';
I.e., does the collation function actually work?
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
