yes, you are right. I'd better to go to sleep now -:)
On Fri, Oct 16, 2009 at 2:23 AM, P Kishor <punk.k...@gmail.com> wrote:
> On Fri, Oct 16, 2009 at 1:42 AM, Michael Chen
> <vancouver.mich...@gmail.com> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Best regards,
Michael Chen
Google Voice Phone.: 847-448-0647
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
