On Sun, Jan 29, 2012 at 5:55 AM, Dmitriy Igrishin <dmitigr@xxxxxxxxx> wrote: >> The point here is that you can exploit the tree structure with a btree >> index. Before we got recursive queries, this was often the best way >> to do it, but now it's kind of a niche solution to be used when >> certain things fall into place. >> >> merlin > > Another approarch is to use ltree. It's easy and robust. > http://www.postgresql.org/docs/9.1/static/ltree.html yeah -- good point. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general