Hi, On 20 August 2012 11:28, Chris Travers <chris.travers@xxxxxxxxx> wrote: > I have been reading up on object-relational features of Oracle and DB2 and > found that one of the big things they have that we don't is a path operator. > The idea is that you can use the path operator to follow some subset of > foreign keys called refs. <snip> > Any thoughts? If it can be done in plain SQL and inlined that would be > ideal but in the prototyping state, that isn't so important and I expect > that it is not. You should look at ltree: This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching through label trees are provided. http://www.postgresql.org/docs/9.1/static/ltree.html -- Ondrej Ivanic (ondrej.ivanic@xxxxxxxxx) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
