# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1553169219 -3600
# Node ID 018f979f9e23a45e2a1794a83c5a468fd0c7ad44
# Parent  5da81634bdc4ae37c5a313ff72c422cf807c682d
Bottlenecks import allow ISRS_from > ISRS_to.

The order constraint on isrsranges are arbitrary and should be
satisfied by the WAMOS back end not by the user data.

diff -r 5da81634bdc4 -r 018f979f9e23 pkg/imports/bn.go
--- a/pkg/imports/bn.go	Thu Mar 21 12:33:43 2019 +0100
+++ b/pkg/imports/bn.go	Thu Mar 21 12:53:39 2019 +0100
@@ -64,9 +64,12 @@
   isrs_fromText($2),
   $3,
   $4,
-  isrsrange(isrs_fromText($5), isrs_fromText($6)),
+  isrsrange(least(isrs_fromText($5), isrs_fromText($6)),
+            greatest(isrs_fromText($5), isrs_fromText($6))),
   ISRSrange_area(
-    ISRSrange_axis(isrsrange(isrs_fromText($5), isrs_fromText($6)), $14),
+    ISRSrange_axis(isrsrange(least(isrs_fromText($5), isrs_fromText($6)),
+                             greatest(isrs_fromText($5), isrs_fromText($6))),
+                   $14),
     (SELECT ST_Collect(CAST(area AS geometry))
         FROM waterway.waterway_area)),
   $7,