fix #567: export operative roundabouts only once
Created by: das-g
fixes #567 (closed)
also partially fixes #565 (closed): non-operative roundabouts now only present in nonop_l
, not in road_l
Reviewed by
-
@hixi -
@sfkeller
Merge request reports
Activity
Created by: das-g
@sfkeller: Do you know what kinda construct
IS DISTINCT FROM
is, syntactically? (Its semantics in PostgreSQL are known to me.)Although it isn't listed in the table of comparison operators, I would have assumed that it is a comparison operator, too. After all, 9.2. Comparison Operators is the documentation section where it's documented.
Though, other than the comparison operators, it cannot be used with the
ALL
array comparison:some_expression IS DISTINCT FROM ALL ('some value', 'another value', 'yet another')
is not a valid PostgreSQL expression for some reason. (If it was, it should IMHO be equivalent to
some_expression IS DISTINCT FROM 'some value' AND some_expression IS DISTINCT FROM 'another value' AND some_expression IS DISTINCT FROM 'yet another'
and to
some_expression IS NOT NULL AND some_expression NOT IN ('some value', 'another value', 'yet another')
.)
Please register or sign in to reply