Avoid {NULL} arrays in reporter schema definitions user/dbs/reporter_array_nulls
authorDan Scott <dscott@laurentian.ca>
Tue, 29 Nov 2011 20:15:15 +0000 (15:15 -0500)
committerDan Scott <dscott@laurentian.ca>
Wed, 30 Nov 2011 04:02:22 +0000 (23:02 -0500)
commit5758682f3750cd2e14cc485267ce7692a7301945
tree68d34351572fe24f63445fddd11b31d28dcfb3b0
parentc1202c1492a210ea51610a164d938faef4a4d28c
Avoid {NULL} arrays in reporter schema definitions

Whether we use ARRAY_ACCUM() or ARRAY_AGG(), we seem to get {NULL} array
values back which then prevent reporter.materialized_simple_record from
being populated with the new value (possibly because the
regexp_replace() calls return a NULL on NULL input?). In any case, some
CASE statements avoid that nonsense entirely.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/reporter-schema.sql