projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1495625) | patch
Reference LP# 1206936. Money views have been using the last()
authorChris Sharp <csharp@georgialibraries.org>
Wed, 31 Jul 2013 17:45:41 +0000 (13:45 -0400)
committerChris Sharp <csharp@georgialibraries.org>
Wed, 31 Jul 2013 17:45:41 +0000 (13:45 -0400)
commit765aa89f65c9bda6296085cca9396daad62b5dc6
treefcb0b75d81f7b91ad9786bddcf76008ae43a3996tree
parent14956259a3c5f23c2255de3f0c33533555f4d80dcommit | diff
Reference LP# 1206936.  Money views have been using the last()
aggregate function to get the "last" value of billing type and
billing notes.  Mike Rylander suggested the approach of using
window functions to accomplish the same thing, grabbing the
correct data in the process.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Open-ILS/src/sql/Pg/080.schema.money.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.money.replace_views_with_window_functions.sql [new file with mode: 0644] blob
Evergreen ILS