すべてのプロダクト
Search
ドキュメントセンター

PolarDB:<->

最終更新日:Jun 21, 2024

This topic describes the <-> operator. This operator calculates the 3D distance between two sfmesh objects or two meshgeom objects.

構文

double <->(sfmesh A, sfmesh B);
double <->(meshgeom A, meshgeom B);

パラメーター

項目説明
AThe sfmesh object A or meshgeom object A.
BThe sfmesh object B or meshgeom object B.

説明 

The operator returns the 3D distance between the centroids of two sfmesh objects or two meshgeom objects.

select '{"version" : 1, "root" : 0, "meshgeoms" : ["MESHGEOM(PATCH(INDEXSURFACE Z (VERTEX(307248.723802283 296449.440306073 6500.00004882812,307248.723802283 296449.440306073 100,307258.460240141 296449.440306073 6500.00004882812,307258.460240141 296449.440306073 100,307258.460240141 296474.440306263 6500.00004882812,307258.460240141 296474.440306263 100,307248.723802283 296474.440306263 6500.00004882812,307248.723802283 296474.440306263 100),INDEX((0,1,2),(3,2,1),(4,5,6),(7,6,5),(3,1,7),(7,5,3),(2,3,4),(5,4,3),(0,2,4),(4,6,0),(1,0,7),(6,7,0)))))"], "primitives" : [{"meshgeom" : 0}], "nodes" : [{"primitive" : 0}]}'::mesh <-> the_mesh from mesh_gist_test limit 1;
-------------------------------------
3229821.634972401