Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6177:573112007ec7
Remove stray semicolon from sql schema.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Tue, 04 Jun 2013 10:27:54 +0200 |
| parents | 6cdb3ee687a9 |
| children | 0711ce5ca701 |
comparison
equal
deleted
inserted
replaced
| 6176:4edad3e414cb | 6177:573112007ec7 |
|---|---|
| 257 JOIN wst_q_ranges wqr | 257 JOIN wst_q_ranges wqr |
| 258 ON wcqr.wst_q_range_id=wqr.id | 258 ON wcqr.wst_q_range_id=wqr.id |
| 259 JOIN ranges r | 259 JOIN ranges r |
| 260 ON wqr.range_id=r.id | 260 ON wqr.range_id=r.id |
| 261 JOIN wst_column_values wcv | 261 JOIN wst_column_values wcv |
| 262 ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b; | 262 ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b |
| 263 ORDER BY wcv.position ASC, | 263 ORDER BY wcv.position ASC, |
| 264 wc.position DESC; | 264 wc.position DESC; |
| 265 | 265 |
| 266 -- view to select the w values of a WST | 266 -- view to select the w values of a WST |
| 267 CREATE VIEW wst_w_values AS | 267 CREATE VIEW wst_w_values AS |