Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
timgraham opened this issue Nov 25, 2020 · 3 comments
Labels
O-community Originated from the community T-spatial Spatial Team X-blathers-triaged blathers was able to find an owner

Comments

@timgraham
Copy link
Contributor

timgraham commented Nov 25, 2020

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

@blathers-crl
Copy link

blathers-crl bot commented Nov 25, 2020

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

  • @rafiss (found keywords: psycopg2)

If we have not gotten back to your issue within a few business days, you can try the following:

  • Join our community slack channel and ask on #cockroachdb.
  • Try find someone from here if you know they worked closely on the area and CC them.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

@blathers-crl blathers-crl bot added O-community Originated from the community X-blathers-triaged blathers was able to find an owner labels Nov 25, 2020
@jlinder jlinder added the T-spatial Spatial Team label Jun 16, 2021
@github-actions
Copy link

github-actions bot commented Sep 6, 2023

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@timgraham
Copy link
Contributor Author

Still a valid issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
O-community Originated from the community T-spatial Spatial Team X-blathers-triaged blathers was able to find an owner
Projects
None yet
Development

No branches or pull requests

2 participants