rt_tl);
> sqlite3_bind_double(insert_tl, 1, 3.3);
> rc = sqlite3_step(insert_tl);
> if (rc != SQLITE_DONE)
>exit(rc);
>
>
> sqlite3_stmt* select_tl;
> rc = sqlite3_prepare_v2(db, "select * from tl",-1,_tl,NULL);
> if (rc != SQLITE_OK)
>exit(rc);
>
E_OK)
exit(rc);
while ( sqlite3_step(select_tl) == SQLITE_ROW){
printf("%e",sqlite3_column_double(select_tl,0));
printf("\n");
}
if (rc != SQLITE_DONE)
exit(rc);
sqlite3_finalize(select_tl);
sqlite3_close(db);
printf("exit normal
"safe")
> way of getting the "infinity" value in C++.
>
> In the Visual C++ 2005 compiler, the max double is
> 1.7976931348623158e+308. I'm not sure that this is constant however, so
> don't count on it.
>
> -Original Message-
> From: sqlite-users-bou
t
> 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
weh...@gmail.com>wrote:
> On Fri, Oct 16, 2009 at 1:41 PM, Michael Chen
> <vancouver.mich...@gmail.com> wrote:
> > rdbms is indeed not a place for store a single sparse matrix like this.
> > However I have hundreds of them, and I need to break them and recombine
> them
&g
as needed. For example, Perl's freeze,
> thaw are tailor made for this kind of stuff.
>
>
> On Fri, Oct 16, 2009 at 1:09 PM, Michael Chen
> <vancouver.mich...@gmail.com> wrote:
> > --this is my first version for the purpose of storing sparse numerical
> > matri
it like this:
>
> select a1.rowid, ifnull(sum(a2.ct), 0) + 1 as IA
> from rowwiseB a1 left outer join rowwiseB a2 on a2.rowid < a1.rowid
> group by a1.rowid;
>
>
> Pavel
>
> On Fri, Oct 16, 2009 at 2:09 PM, Michael Chen
> <vancouver.mich...@gmail.com> wrote:
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, '
select *, (length(path) - length( replace(path, '/','' )) +1 ) as depth
from tree;
which returns 5 for a path field "/1/2/5/", shouldn't it be 3?
--
Best regards,
Michael Chen
Google Voice Phone.: 847-448-0647
___
sqlite-users mailing l
mysql.com/tech-resources/articles/hierarchical-data.html
> >
> > is for mysql but aplies to every sql DB
> >
> >
> > - Mensaje original
> > De: Michael Chen <vancouver.mich...@gmail.com>
> > Para: sqlite-users@sqlite.org
> > Enviado: miƩ,
gt;
> Create view tree as
> Select * from tree_node where distance_from_root=0;
>
> All kinds of denormalizations and elaborations possible from here...
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On
on this?
Michael Chen
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
12 matches
Mail list logo