Skip to content

sql: support strictly above (|>>) and strictly below (<<|) bounding box operators #57095

Open
@timgraham

Description

They should adopt PostGIS behavior:
https://postgis.net/docs/ST_Geometry_Above.html
https://postgis.net/docs/ST_Geometry_Below.html

Currently they fail like this:

psycopg2.errors.SyntaxError: at or near ">": syntax error
DETAIL:  source SQL:
SELECT "geoapp_city"."id", "geoapp_city"."name", "geoapp_city"."point"::bytea FROM "geoapp_city" WHERE "geoapp_city"."point" |>> ST_GeomFromEWKB('\x0101000020e6100000494739984d3358c0cf4d9b711a644040'::bytea) ORDER BY "geoapp_city"."name" ASC

Jira issue: CRDB-2867

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions