Mercurial > gemma
comparison pkg/imports/wx.go @ 5021:6fe3662aafeb
Add explaining comment
Since the commented filter condition logically adds nothing to
the WHERE clause here, explain why it's there.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 16 Mar 2020 15:19:13 +0100 |
| parents | e4ab338e7ba9 |
| children | 6270951dda28 |
comparison
equal
deleted
inserted
replaced
| 5020:e4ab338e7ba9 | 5021:6fe3662aafeb |
|---|---|
| 59 -- Do nothing if intersection is empty: | 59 -- Do nothing if intersection is empty: |
| 60 WHERE NOT ST_IsEmpty(new_ax) | 60 WHERE NOT ST_IsEmpty(new_ax) |
| 61 ), | 61 ), |
| 62 t AS ( | 62 t AS ( |
| 63 UPDATE waterway.waterway_axis SET last_found = current_timestamp | 63 UPDATE waterway.waterway_axis SET last_found = current_timestamp |
| 64 -- The first condition is just to help the PostgreSQL query planner | |
| 65 -- to avoid evaluating more costly conditions including those | |
| 66 -- introduced by row level security policies: | |
| 64 WHERE (SELECT new_ax FROM g) IS NOT NULL | 67 WHERE (SELECT new_ax FROM g) IS NOT NULL |
| 65 AND validity @> current_timestamp | 68 AND validity @> current_timestamp |
| 66 AND ( | 69 AND ( |
| 67 wtwaxs, objnam, nobjnam | 70 wtwaxs, objnam, nobjnam |
| 68 ) IS NOT DISTINCT FROM ( | 71 ) IS NOT DISTINCT FROM ( |