Mercurial > dive4elements > river
comparison flys-backend/ChangeLog @ 755:a29fd0916803
Added a new view to select qs of a WST.
flys-backend/trunk@1988 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 24 May 2011 11:12:59 +0000 |
| parents | 5bcf338eadb9 |
| children | ca13926b8871 |
comparison
equal
deleted
inserted
replaced
| 754:5bcf338eadb9 | 755:a29fd0916803 |
|---|---|
| 1 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de> | |
| 2 | |
| 3 * doc/schema/postgresql.sql: Added a new view to select qs of a WST. | |
| 4 To update existing databases: | |
| 5 | |
| 6 CREATE VIEW wst_q_values AS | |
| 7 SELECT wc.position AS column_pos, | |
| 8 wqr.q AS q, | |
| 9 r.a AS a, | |
| 10 r.b AS b, | |
| 11 wc.wst_id AS wst_id | |
| 12 FROM wst_column_q_ranges wcqr | |
| 13 JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id | |
| 14 JOIN ranges r ON wqr.range_id = r.id | |
| 15 JOIN wst_columns wc ON wcqr.wst_column_id = wc.id | |
| 16 ORDER BY wc.position, wcqr.wst_column_id, r.a; | |
| 17 | |
| 1 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de> | 18 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de> |
| 2 | 19 |
| 3 * doc/schema/postgresql.sql: Added a new view to select ws of a WST. | 20 * doc/schema/postgresql.sql: Added a new view to select ws of a WST. |
| 4 To update existing databases: | 21 To update existing databases: |
| 5 | 22 |