Mercurial > gemma
diff pkg/wfs/global.go @ 3003:92818da6133d
Cleanup VIEW definition
NULLS LAST is not necessary on non-nullable columns;
avoid materializing unused columns in a CTE;
use boolean value directly instead of comparing to auto-casted string;
gauge_measurements might contain not only waterlevels;
avoid unnecessary subselects.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 10 Apr 2019 18:50:20 +0200 |
parents | 2b6f73c30016 |
children | 04876d865528 |