--- a/flys-backend/ChangeLog	Mon May 23 15:01:58 2011 +0000
+++ b/flys-backend/ChangeLog	Tue May 24 10:49:14 2011 +0000
@@ -1,3 +1,18 @@
+2011-05-24	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Added a new view to select ws of a WST.
+	  To update existing databases:
+
+	    CREATE VIEW wst_w_values AS
+	        SELECT wcv."position" AS km, 
+	               wcv.w          AS w,  
+	               wc."position"  AS column_pos, 
+	               w.id           AS wst_id
+	            FROM wst_column_values wcv
+	            JOIN wst_columns wc ON wcv.wst_column_id = wc.id
+	            JOIN wsts w         ON wc.wst_id = w.id
+	        ORDER BY wcv."position", wc."position";
+
 2011-05-23	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	 flys/issue76