Skip to content
Snippets Groups Projects

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

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Created by: hixi

    :thumbsup:

  • 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')

    .)

  • Merged by: das-g at 2016-06-15 15:18:59 UTC

Please register or sign in to reply
Loading