]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Revise the updatable views for the various types of query.expression:
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 8 May 2010 20:17:42 +0000 (20:17 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 8 May 2010 20:17:42 +0000 (20:17 +0000)
commitf7fea567240164c04c669b4b87ee5dcabb0e41ef
tree402a2f11a1b01400805e9b57a883c5093fc717d9
parentc48abb941e2243d31886890ebe79ffea6978af07
Revise the updatable views for the various types of query.expression:

1. Rename query.expr_string to query.expr_xstr, for consistency.

2. Add a "negate" column to each view, except for query.expr_xnum
and query.expr_xstr.

3. Add a "left_operand" column to query.expr_xin, correcting an
earlier oversignt.

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/0253.schema.query_expr_view.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16408 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/008.schema.query.sql
Open-ILS/src/sql/Pg/upgrade/0253.schema.query_expr_view.sql [new file with mode: 0644]