For various updatable views based on query.expression:
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sun, 30 May 2010 03:50:47 +0000 (03:50 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sun, 30 May 2010 03:50:47 +0000 (03:50 +0000)
commitc2c30505e8e3e05d0dc64b5a3f8e5a88cd5a61c2
treeaa69f5f8617c46b54f2d6093a601767d9ebc7250
parentda10e38318098e5b7ceff05e4c9fd118aed2749f
For various updatable views based on query.expression:
add COALESCE to the insert rule so that we don't always
have to specify a value for the "negate" column.

Also: eliminate a harmless but annoying duplication of
the create statements for the query.expr_xbind view.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0286.schema.query-coalesce-negate.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16536 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/008.schema.query.sql
Open-ILS/src/sql/Pg/upgrade/0286.schema.query-coalesce-negate.sql [new file with mode: 0644]