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
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
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
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
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
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