Re: [SQL] rows in order

2002-10-04 Thread Joe Conway
Camila Rocha wrote: > Is there a way to put in order the rows in a table? the problem is that i w= > ant to keep a "tree" in the db, but the leaves must be ordered... > does someone have an idea? If you don't mind trying 7.3 beta, there is a function called connectby() in contrib/tablefunc. It w

Re: [SQL] rows in order

2002-10-04 Thread Oleg Bartunov
On Fri, 4 Oct 2002, Achilleus Mantzios wrote: > > How do you plan to keep your tree represented?? > > There are quite a few options for this. > Extensive talk has been made in this list. > Also search the archives. > Basically you can follow > - nested trees (pure sql) aproach > - Genealogical tr

Re: [SQL] rows in order

2002-10-04 Thread Richard Huxton
On Monday 30 Sep 2002 7:29 pm, Camila Rocha wrote: > Hi! > > Is there a way to put in order the rows in a table? the problem is that i > want to keep a "tree" in the db, but the leaves must be ordered... does > someone have an idea? Do a search on "Joe Celko" and "tree" and you should find a clea

Re: [SQL] rows in order

2002-10-04 Thread Achilleus Mantzios
How do you plan to keep your tree represented?? There are quite a few options for this. Extensive talk has been made in this list. Also search the archives. Basically you can follow - nested trees (pure sql) aproach - Genealogical tree representation approach (either using text to represent the

[SQL] rows in order

2002-10-04 Thread Camila Rocha
Hi!   Is there a way to put in order the rows in a table? the problem is that i want to keep a "tree" in the db, but the leaves must be ordered... does someone have an idea?   thanks,   Camila