-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/28/2011 07:39 PM, Simon Slavin wrote: > Actually I don't see how BLOBs can be used in an index anyway, since > technically blobs have no ordering.
memcmp provides an ordering just as it can for strings without a collation. (That is what SQLite implements - you can decide how that complies with "SQL".) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk4yHnIACgkQmOOfHg372QQ2lACgighSjQE9YWG4PyV0ZJh3niCj oHgAn2pn23N0ZQtJ8f2pZS84lg2PS8fN =csl7 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
