Bring located URIs back into unapi search results
authorDan Scott <dan@coffeecode.net>
Sun, 11 Mar 2012 19:52:40 +0000 (15:52 -0400)
committerDan Scott <dan@coffeecode.net>
Sat, 17 Mar 2012 18:24:39 +0000 (14:24 -0400)
commitb2baa8ee045cc2bf10345ab7c8f068708126103e
treeebf42d25a8bee18543f5bc68db4e7b44e50934f3
parenta33caec9dc73fefbad60216c70bd7aad40128db4
Bring located URIs back into unapi search results

When we ordered results by copy name and added the copy table to the
join, we eliminated all call numbers for located URIs (because they
don't have copies, naturally).

Rectify that in a crude UNION of the results, with located URIs from the
preferred library (if any) favoured of those of the search library.

Signed-off-by: Dan Scott <dan@coffeecode.net>
Open-ILS/src/sql/Pg/990.schema.unapi.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.unapi_limit_rank.sql