changeset 5529:52876daf97b0

Use left join on time intervals as they can be NULL
author Tom Gottfried <tom@intevation.de>
date Tue, 02 Apr 2013 13:02:12 +0200 (2013-04-02)
parents 33d735f5433e
children 7f8d6b49afad
files flys-artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/flys-artifacts/doc/conf/meta-data.xml	Tue Apr 02 08:58:24 2013 +0200
+++ b/flys-artifacts/doc/conf/meta-data.xml	Tue Apr 02 13:02:12 2013 +0200
@@ -896,7 +896,7 @@
                          d.projection || ' | ' || t.start_time || ' - ' || t.stop_time AS info
                          FROM dem d
                          JOIN ranges r ON d.range_id = r.id
-                         JOIN time_intervals t ON d.time_interval_id = t.id
+                         LEFT JOIN time_intervals t ON d.time_interval_id = t.id
                          WHERE d.river_id = ${river_id}
                 </dc:statement>
                 <dc:for-each>

http://dive4elements.wald.intevation.org