New version of actor.org_unit_ancestors
authorThomas Berezansky <tsbere@mvlc.org>
Thu, 11 Aug 2011 13:35:18 +0000 (09:35 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 23 Aug 2011 18:32:41 +0000 (14:32 -0400)
commit2cb3b3d1c9ee48b34bc5fce74bb403582bebb92c
treeeb6f71557fab509c2a5df135d2b1921b542a23ed
parentfffe9d65e508dc998356de104f5a372857e167b6
New version of actor.org_unit_ancestors

Preserves order through joins

Basically actor.org_unit_ancestors_distance with a join to get the
entire org units, rather than just IDs and a distance.

Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/020.schema.functions.sql