Re: Hierarchical queries

From: Anton(dot)Nikiforov(at)loteco(dot)ru
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Andrew Rawnsley <ronz(at)ravensfield(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Hierarchical queries
Date: 2004-01-12 05:04:17
Message-ID: 903930682.20040112080417@loteco.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Joe,
But this function is not giving a path from one element to other, it
is just truncating the tree beginning from the start element, but it
is not rotating the whole tree making starting element a tree's root.

JC> See contrib/tablefunc for a function called connectby().

Regards,
Anton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ezra epstein 2004-01-12 05:18:58 Precedence of a TRIGGER vs. a CHECK on a column
Previous Message Sai Hertz And Control Systems 2004-01-12 04:31:17 Re: OIDS and its limitations