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>
Mon, 10 Nov 2014 14:06:19 +0000 (09:06 -0500)
commit2a3deb55e9520aa9a381e2b39c58eaf88687ac5e
treecb7034f6ac24effdf7b56d47e91cd04b21ca3f80
parent8a5f306fa362e502ef864c2c0d0a0666343a7416
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.

Fixing typo in the upgrade script.

Fix typos in both changed files!

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