Added loc_or_locgroup function
authorDoug Kyle <dkyle@grpl.org>
Thu, 3 Apr 2014 18:24:34 +0000 (14:24 -0400)
committerDoug Kyle <dkyle@grpl.org>
Thu, 3 Apr 2014 18:24:34 +0000 (14:24 -0400)
commit27124a4e6bd93cc4fe55a9867f759a708dd434e5
treee3c17ed605aa2c0db33579d2e509fe2627f0af49
parentc4f4b5734bfe42159100e21ae7baf83b01f7abb6
Added loc_or_locgroup function

Intended to to make the shelf_is_group config attribute usefull by
replacing joins to smart_float.config based on copy.location with
joins based on loc_or_locgroup(copy.location). The mapping of multiple
locations to a single group config record works but performance was
significantly slower. Need to speed it up or do something else.

Signed-off-by: Doug Kyle <dkyle@grpl.org>
Open-ILS/src/sql/Pg/smart_float.sql