>What should substr('abcd',0,-2) return? 'cd' or just 'd'? Or maybe just an
>empty string?
You’re starting at position 0 (in the imaginary infinite array) and taking the
two characters to the left of that which are ‘\0’, so an empty string.
substr(‘abcd’,0,2) on the other hand should return array[0]+array[1] = ‘a’
Seems fairly consistent to me.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
