Module postgis_diesel::operators

source ·

Functions§

  • bb_same
    The ~= operator returns TRUE if the bounding box of geometry/geography A is the same as the bounding box of geometry/geography B.
  • contained_by
    The @ operator returns TRUE if the bounding box of geometry A is completely contained by the bounding box of geometry B.
  • contains
    The ~ operator returns TRUE if the bounding box of geometry A completely contains the bounding box of geometry B.
  • distance_2d
    The <-> operator returns the 2D distance between A and B.
  • distance_2d_bbs
    The <#> operator returns the 2D distance between A and B bounding boxes.
  • distance_3d_trajectories
    The |=| operator returns the 3D distance between two trajectories.
  • distance_nd_bbs
    The <<#>> operator returns the n-D distance between A and B bounding boxes.
  • distance_nd_centroids_bbs
    The <<->> operator returns the n-D distance between the centroids of A and B bounding boxes.
  • g_same
    The = operator returns TRUE if the coordinates and coordinate order geometry/geography A are the same as the coordinates and coordinate order of geometry/geography B.
  • intersects_2d
    The && operator returns TRUE if the 2D bounding box of geometry A intersects the 2D bounding box of geometry B.
  • overlaps_or_above
    The |&> operator returns TRUE if the bounding box of geometry A overlaps or is above the bounding box of geometry B, or more accurately, overlaps or is NOT below the bounding box of geometry B.
  • overlaps_or_below
    The &<| operator returns TRUE if the bounding box of geometry A overlaps or is below of the bounding box of geometry B, or more accurately, overlaps or is NOT above the bounding box of geometry B.
  • overlaps_or_left
    The &< operator returns TRUE if the bounding box of geometry A overlaps or is to the left of the bounding box of geometry B, or more accurately, overlaps or is NOT to the right of the bounding box of geometry B.
  • overlaps_or_right
    The &> operator returns TRUE if the bounding box of geometry A overlaps or is to the right of the bounding box of geometry B, or more accurately, overlaps or is NOT to the left of the bounding box of geometry B.
  • strictly_above
    The |>> operator returns TRUE if the bounding box of geometry A is strictly above the bounding box of geometry B.
  • strictly_below
    The <<| operator returns TRUE if the bounding box of geometry A is strictly below the bounding box of geometry B.
  • strictly_left
    The << operator returns TRUE if the bounding box of geometry A is strictly to the left of the bounding box of geometry B.
  • strictly_right
    The >> operator returns TRUE if the bounding box of geometry A is strictly to the right of the bounding box of geometry B.