Re: [GENERAL] Sorting with materialized paths

2010-05-10 Thread Thomas Kellerer
Ovid wrote on 09.05.2010 15:33: My apologies. This isn't PG-specific, but since this is running on PostgreSQL 8.4, maybe there are specific features which might help. I have a tree structure in a table and it uses materialized paths to allow me to find children quickly. However, I also need to s

Re: [GENERAL] Sorting with materialized paths

2010-05-10 Thread Alban Hertroys
On 10 May 2010, at 20:06, Greg Stark wrote: > On Sun, May 9, 2010 at 4:47 PM, Tom Lane wrote: >> Ovid writes: >>> My apologies. This isn't PG-specific, but since this is running on >>> PostgreSQL 8.4, maybe there are specific features which might help. >>> I have a tree structure in a table and

Re: [GENERAL] Sorting with materialized paths

2010-05-10 Thread Greg Stark
On Sun, May 9, 2010 at 4:47 PM, Tom Lane wrote: > Ovid writes: >> My apologies. This isn't PG-specific, but since this is running on >> PostgreSQL 8.4, maybe there are specific features which might help. >> I have a tree structure in a table and it uses materialized paths to allow >> me to find

Re: [GENERAL] Sorting with materialized paths

2010-05-10 Thread Peter Hunsberger
On Sun, May 9, 2010 at 8:33 AM, Ovid wrote: > My apologies. This isn't PG-specific, but since this is running on PostgreSQL > 8.4, maybe there are specific features which might help. > > I have a tree structure in a table and it uses materialized paths to allow me > to find children quickly. How

Re: [GENERAL] Sorting with materialized paths

2010-05-09 Thread Tom Lane
Ovid writes: > My apologies. This isn't PG-specific, but since this is running on PostgreSQL > 8.4, maybe there are specific features which might help. > I have a tree structure in a table and it uses materialized paths to allow me > to find children quickly. However, I also need to sort the res

[GENERAL] Sorting with materialized paths

2010-05-09 Thread Ovid
My apologies. This isn't PG-specific, but since this is running on PostgreSQL 8.4, maybe there are specific features which might help. I have a tree structure in a table and it uses materialized paths to allow me to find children quickly. However, I also need to sort the results depth-first, as