[OPEN-ILS-DEV] Evergreen SQL Help

[Dan Wells]

Hello,

Let me start by saying SQL is not my strong suit, and Postgres makes it even weaker.  What I am trying to do is write a single Postgres query/function which returns all of a user's work_ous and their ancestors without duplicates.  I see that actor.org_unit_ancestors() is there, and selecting the work_ous is simple enough, but how can one combine them into a single result set?  It seems relatively simple, but I just can't get it right.

Thanks,
Dan

-- 

*********************************************************************************
Daniel Wells, Library Programmer Analyst dbw2 at calvin.edu
Hekman Library at Calvin College
616.526.7133