]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Added a stored procedure to find the first occurrence of an org-unit setting for...
authorerickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 17 Nov 2008 23:30:05 +0000 (23:30 +0000)
committererickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 17 Nov 2008 23:30:05 +0000 (23:30 +0000)
commit5688a20cef68a5eae883b38a9ad85e6ce12c239b
tree8cd14ba750b775a731f1eab6f98619ea4f3bf8fa
parent6125704dfe7db9c598fe086e041bb86c31a39848
Added a stored procedure to find the first occurrence of an org-unit setting for a specified org unit.
This is an optimization over the existing process of going back/forth from the middle-layer apps and cstore.
Plugged stored proc into utility code.

* The stored proc is the product of my non-SQL brain.  It's very linear and could probably be optimized...

git-svn-id: svn://svn.open-ils.org/ILS/trunk@11250 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/perlmods/OpenILS/Application/AppUtils.pm
Open-ILS/src/sql/Pg/020.schema.functions.sql