Skip to content

sql: support same as (~=) bounding box operator #57096

@timgraham

Description

@timgraham

It should adopt PostGIS behavior:
https://postgis.net/docs/ST_Geometry_Same.html

Currently it fails like this:

psycopg2.errors.SyntaxError: at or near "=": syntax error
DETAIL:  source SQL:
SELECT "geoapp_state"."id", "geoapp_state"."name", "geoapp_state"."poly"::bytea FROM "geoapp_state" WHERE "geoapp_state"."poly" ~= ST_GeomFromEWKB('\x0101000020e6100000000000000000f03f000000000000f03f'::bytea)

Jira issue: CRDB-2866

Metadata

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