Re: [sqlite] recursive select in sqlite

2010-05-17 Thread Jean-Christophe Deschamps
>z> i wonder is there RECURSIVE select function in sqlite? the background >z> for the question are: create table objects (id INTEGER PRIMARY KEY >z> AUTOINCREMENT, name text unique) create table tree(id int, child_id >z> int, PRIMARY KEY(id, child_id)) i want to draw the w

Re: [sqlite] recursive select in sqlite

2010-05-17 Thread Jay A. Kreibich
On Mon, May 17, 2010 at 09:40:32PM +0800, zeal scratched on the wall: > dear Sqlite group, > i wonder is there RECURSIVE select function in sqlite? the background > for the question are: > create table objects (id INTEGER PRIMARY KEY AUTOINCREMENT, name text unique) > create ta

Re: [sqlite] recursive select in sqlite

2010-05-17 Thread Swithun Crowe
Hello z> i wonder is there RECURSIVE select function in sqlite? the background z> for the question are: create table objects (id INTEGER PRIMARY KEY z> AUTOINCREMENT, name text unique) create table tree(id int, child_id z> int, PRIMARY KEY(id, child_id)) i want to draw th

[sqlite] recursive select in sqlite

2010-05-17 Thread zeal
dear Sqlite group, i wonder is there RECURSIVE select function in sqlite? the background for the question are: create table objects (id INTEGER PRIMARY KEY AUTOINCREMENT, name text unique) create table tree(id int, child_id int, PRIMARY KEY(id, child_id)) i want to draw the whole tree