The SQL docs include functions we have stubs for but haven't implemented yet

[petern48]

Hmm, some functions have been marked as completed in this list, and their documentations exist in sql.md, even though we haven't actually implemented them. It's because we have stubs for the functions, and the docs got generated for them (e.g ST_HausdorffDistance)

Originally posted by @petern48 in #174

We should fix this soon. It is confusing users. e.g. #174 (comment). IMO, I think we should not only delete them from the docs, but also delete the stub functions to avoid confusion when people search the codebase

[petern48]

cc @MrPowers

[petern48]

I can't think of a super-efficient way to find all of these unused stubs other than just manually testing the functions. I don't think there are too many at least. From the top of my head a few that we need to remove are most of the distance ones. e.g. DistanceSphere, DistanceSpheroid, FrechetDistance,

[wangwuhua11]

I can't think of a super-efficient way to find all of these unused stubs other than just manually testing the functions. I don't think there are too many at least. From the top of my head a few that we need to remove are most of the distance ones. e.g. DistanceSphere, DistanceSpheroid, FrechetDistance,

I feel that the “DistanceSpheroid ” function is still widely used，Which version has implementation plans in the future?
I'm not sure if there is a correlation，Does the “use_sthenoid ” parameter in ST_KNN (A: Geometry, B: Geometry, k: Integer, use_sthenoid: Boolean) take effect?

[paleolimbot]

I believe the PR that removed these from the documentation has been merged...Matthew kindly ran all of the examples by hand which identified these cases nicely (we can also run the examples as a CI job but haven't implemented this yet).

Specifically for "Distance Spheroid", a workaround ST_Distance() for geography. We don't have a great way to cast to geography at the moment but a workaround is to go through WKB. Sometime in January we will have a release that makes this operation faster/more ergonomic).

SELECT ST_Distance(ST_GeogFromWKB(ST_AsBinary(geom1)), ST_GeogFromWKB(ST_AsBinary(geom2))) as d

Does the “use_sthenoid ” parameter in ST_KNN (A: Geometry, B: Geometry, k: Integer, use_sthenoid: Boolean) take effect?

I believe it does!