]> git.evergreen-ils.org Git - Evergreen.git/commit
Prevent {NULL} values from blocking bib saving
authorDan Scott <dscott@laurentian.ca>
Tue, 3 Jan 2012 16:53:49 +0000 (11:53 -0500)
committerDan Scott <dscott@laurentian.ca>
Fri, 7 Feb 2014 22:00:16 +0000 (17:00 -0500)
commitfc5bd43ec0fda187efa34b001b84ca6919b10f43
tree3b3518a58e6f23268170eab87f8f2347c9aeb6a3
parent29b2929c394211f9a3ac5fe64b78b9698ae2a58e
Prevent {NULL} values from blocking bib saving

With both the old ARRAY_ACCUM and ARRAY_AGG, and with array_nulls on,
PostgreSQL 9.0 on Debian Squeeze was generating values of '{NULL}'
rather than actual nulls. This would in turn prevent bibs without ISBNs
or ISSNs from being saved successfully. A CASE statement protects
against that problem and returns a clean NULL.

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