Re: [sqlite] how to represent a tree in SQL

2009-10-15 Thread Michael Chen
> > Sebastian Bermudez > > Sent: Wednesday, October 14, 2009 5:10 PM > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] how to represent a tree in SQL > > > > > > > > look this: > > > > http://dev.mysql.com/tech-resources/artic

Re: [sqlite] how to represent a tree in SQL

2009-10-14 Thread Cariotoglou Mike
o:[email protected]] On Behalf Of > Sebastian Bermudez > Sent: Wednesday, October 14, 2009 5:10 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] how to represent a tree in SQL > > > > look this: > > http://dev.mysql.com/tech-resources/arti

Re: [sqlite] how to represent a tree in SQL

2009-10-14 Thread Michael Chen
e/more-trees-hierarchies-in-sql > ..ooops, I appear to have stayed off topic. Apologies. > > > -Original Message- > From: [email protected] > [mailto:[email protected]] On Behalf Of Hoover, Jeffrey > Sent: Wednesday, October 14, 2009 2:51 PM >

Re: [sqlite] how to represent a tree in SQL

2009-10-14 Thread Rich Shepard
On Wed, 14 Oct 2009, Michael Chen wrote: > I am developing a numerical application, where a single rooted dynamic > tree is the main data structure. I intended to use SQLite for this purpose > and also for other data as well. However I have no reference how to > represent a tree using tables. I ne

Re: [sqlite] how to represent a tree in SQL

2009-10-14 Thread O'Neill, Owen
stayed off topic. Apologies. -Original Message- From: [email protected] [mailto:[email protected]] On Behalf Of Hoover, Jeffrey Sent: Wednesday, October 14, 2009 2:51 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] how to represent a tree in SQL Isn

Re: [sqlite] how to represent a tree in SQL

2009-10-14 Thread Sebastian Bermudez
look this: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html is for mysql but aplies to every sql DB - Mensaje original De: Michael Chen Para: [email protected] Enviado: mié, octubre 14, 2009 10:40:45 AM Asunto: [sqlite] how to represent a tree in SQL Dear

Re: [sqlite] how to represent a tree in SQL

2009-10-14 Thread Hoover, Jeffrey
here... -Original Message- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Chen Sent: Wednesday, October 14, 2009 9:41 AM To: [email protected] Subject: [sqlite] how to represent a tree in SQL Dear there, I am developing a numerical application,

[sqlite] how to represent a tree in SQL

2009-10-14 Thread Michael Chen
Dear there, I am developing a numerical application, where a single rooted dynamic tree is the main data structure. I intended to use SQLite for this purpose and also for other data as well. However I have no reference how to represent a tree using tables. I need these functionalities: (1) basic t