On Fri, Oct 16, 2009 at 1:42 AM, Michael Chen
<[email protected]> wrote:
> select *, (length(path) - length( replace(path, '/','' )) +1 )
sqlite> SELECT length('/1/2/5/');
7
sqlite> SELECT replace('/1/2/5/', '/', '');
125
sqlite> SELECT length('125');
3
7 - 3 = 4
4 + 1 = 5
sqlite> SELECT (length('/1/2/5/') - length( replace('/1/2/5/', '/','' )) +1 );
5
--
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
