Re: [sqlite] About the substr(x,y,z) core function

2009-08-14 Thread Igor Tandetnik
A.J.Millan wrote: > May be of interest to add in the doc, that, when the second argument > is negative, "the the first character of the substring is found by > counting from the right rather than the left", but remember that the > last actual character is -2, because -1 is just the ending NULL. se

[sqlite] About the substr(x,y,z) core function

2009-08-14 Thread A.J.Millan
Hi List: May be of interest to add in the doc, that, when the second argument is negative, "the the first character of the substring is found by counting from the right rather than the left", but remember that the last actual character is -2, because -1 is just the ending NULL. Of course it is