本文为您介绍如何使用PolarDB PostgreSQL版(Oracle语法兼容1.0)连接器。背景信息 PolarDB PostgreSQL版(兼容Oracle)是阿里巴巴自研的新一代 云原生数据库,在存储计算分离架构下,利用了软硬件结合的优势,为您提供具备极致弹性、高...
产品优势 PolarDB PostgreSQL版(兼容Oracle)2.0版本对PostgreSQL在分布式负载前提下的高并发、高写入负载、并行查询和逻辑复制等方面的性能相比于 PolarDB PostgreSQL版(兼容Oracle)1.0版本有了进一步提升。PolarDB PostgreSQL版(兼容...
数据库 支持的版本 MySQL 4.1、5、5.0、5.1、5.4、5.5、5.6、5.7 Oracle Oracle 9i、Oracle 10g、Oracle 11g、Oracle 12c、Oracle 18c、Oracle 19c、Oracle Data Guard 11g、Oracle Data Guard 12c SQL Server SQL Server 2005、SQL Server...
timeout 30 constraint_exclusion partition cpu_index_tuple_cost 0.005 cpu_operator_cost 0.0025 cpu_tuple_cost 0.01 datestyle 'ISO,YMD' deadlock_timeout 1000 default_with_oids off(Oracle语法兼容2.0)on(Oracle语法兼容1.0)...
uniUserInfoToken"eyJ1cmwiOiJodHRwczovL2EtaGJyLXJlc291cmNlLWhhbmd6aG91Lm9zcy1jbi1oYW5nemhvdS1pbnRlcm5hbC5hbGl5dW5jcy5jb20vY2xpZW50L2luc3RhbGwvZGJhY2t1cF9hZ2VudC93aW42NC84LjAuMjkyOTItMS4wMjg1Nzc2LmRiZy8iLCJob3N0...
如果您正在使用 Oracle语法兼容 1.0版本 或近期有采购计划,请特别关注以下内容:停售日期:2024年3月31日(GMT+8)停止续费日期:2024年9月30日(GMT+8)停止服务日期:2025年3月31日(GMT+8)受影响版本:云原生数据库 PolarDB ...
示例 SELECT ST_NumPatches('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))':...
示例 SELECT ST_AsText(ST_PatchN('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))'...
示例 TRIANGLEFAN(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)同样支持Z和M值 TRIANGLEFAN Z(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLEFAN M(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLEFAN ZM(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)
示例 TRIANGLESTRIP(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)同样支持Z和M值 TRIANGLESTRIP Z(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLESTRIP M(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLESTRIP ZM(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)
将二维Polygon沿Z轴正方向挤出为三维模型。语法 meshgeom ST_Extrude...MESHGEOM(PATCH(POLYGON Z((0 0 1,1 0 1,1 1 1,0 0 1)),TRIANGLESTRIP Z(0 0 1,0 0 0,1 0 1,1 0 0,1 1 1,1 1 0,0 0 1,0 0 0),POLYGON Z((0 0 0,1 1 0,1 0 0,0 0 0))))
从geometry对象构造meshgeom对象。语法 meshgeom ST_MeshGeomFromGeom(geometry geom);参数 参数名称 描述 geom geometry对象。描述 从geometry对象构造meshgeom对象,等同于强制...MESHGEOM(PATCH(POLYGON((0 0 1,10 0 2,10 10 3,0 0 1))))
MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((2,3,0),(0,1,2)))))示例2 SELECT ST_asText(ST_Triangulate('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((0,1,2,3)))))'));MESHGEOM...
从geometry对象构造sfmesh对象。语法 sfmesh ST_MeshFromGeom...st_asewkt-{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON((0 0 1,10 0 2,10 10 3,0 0 1))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))SRID=4326;SOLID=true;MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))
示例 SELECT ST_AsText(ST_RayIntersection('POLYGON((-1-1 0,1-1 0,1 1 0,-1 1 0,-1-1 0))':geometry:meshgeom,'MULTIPOINT(0 0 0,0 1 0,0-1 0,0-2 0)':geometry,'POINT(0 1 0)':geometry));MULTIPOINT Z((0 0 0),(0 1 0),(0-1 0),(0-1 0)...
创建由给定Geometry对象的组成线段所构成的面状对象。语法 geometry ST_BuildArea(geometry a);参数 参数名称 描述 a 目标Geometry对象。描述 输入的线条类对象类型可以是LineString、...st_astext-POLYGON((0 0,0 1,1 1,0 0))(1 row)
2 patches,1 is point and 2 is indexsurface MESHGEOM(PATCH(POINT(0 0 1),INDEXSURFACE(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))-With Norma and texcoord MESHGEOM(PATCH(TRIANGLESTRIP(0 0 1,0 10 2,10 10 3,...
示例 不同类型的返回值:SELECT ST_Zmflag('POINT(0 1)':geometry)as_2D,ST_Zmflag('POINTM(0 1 2)':geometry)as_3DM,ST_Zmflag('POINT(0 1 2)':geometry)as_3DZ,ST_Zmflag('POINT(0 1 2 3)':geometry)as_4D;2d|_3dm|_3dz|_4d-+-+-+-0|1|2|...
在指定范围生成指定数量的伪随机点。语法 geometry ST_GeneratePoints(g geometry,npoints numeric);参数 参数名称 描述 geometry 目标Geometry...示例 默认调用:select ST_GeneratePoints('POLYGON((0 0,1 0,1 1,0 1,0 0))':geometry,30);
返回可以完全包含目标Geometry对象的最小圆形的中心点和半径。...示例 默认调用:select ST_AsText(center),radius from ST_MinimumBoundingRadius('POLYGON((0 1,-1 0,0-1,1 0,0 1))':geometry);st_astext|radius-+-POINT(0 0)|1(1 row)
示例 默认调用:select ST_AsText(ST_Polygonize(array['LINESTRING(0 0,0 1)':geometry,'LINESTRING(0 1,1 1)':geometry,'LINESTRING(1 1,1 0)':geometry,'LINESTRING(0 0,1 0)':geometry]));st_astext-GEOMETRYCOLLECTION(POLYGON((0 0,0...
示例 默认调用:select ST_AsText(ST_GeometryN(g,1)),ST_AsText(ST_GeometryN(g,2))from(select ST_SharedPaths('LINESTRING(-1 0,0 0,0 1)':geometry,'LINESTRING(0 0,0 1,1 1)':geometry)as g)as t;st_astext|st_astext-+-...
返回删除重复点后的目标Geometry对象。语法 geometry ST_RemoveRepeatedPoints...描述 默认调用:select ST_AsText(ST_RemoveRepeatedPoints('POLYGON((0 0,1 0,1 0,1 1,0 0))':geometry));st_astext-POLYGON((0 0,1 0,1 1,0 0))(1 row)
示例 点顺序不一样时也可以相等:SELECT ST_Equals('LINESTRING(0 1,2 3)':geometry,'LINESTRING(2 3,0 1)':geometry);st_equals-t(1 row)空间相等即相等:SELECT ST_Equals('LINESTRING(0 1,0 3)':geometry,'LINESTRING(0 1,0 2,0 3)':...
示例 SELECT ST_3DContains('MESH(INDEXSURFACE Z(VERTEX(0 0 0,0 10 0,0 0 10,10 0 0),INDEX((0,1,2),(1,0,3),(3,0,2),(2,1,3))))':meshgeom,'MESH(TRIANGLESTRIP Z(0.1 0.1 0.1,0.1 1 0.1,0.1 0.1 1,0.1 1 1))':meshgeom);t
通过2D框以快速方式裁剪Geometry对象。语法 geometry ST_ClipByBox2D(geometry geom,...示例 默认调用:SELECT ST_AsText(ST_ClipByBox2D('LINESTRING(0 1,2 1)':geometry,ST_MakeEnvelope(0,0,1,2)));st_astext-LINESTRING(0 1,1 1)(1 row)
将一个坐标点添加到LineString中。语法 geometry ST_AddPoint(geometry linestring,geometry point);geometry ST_AddPoint(geometry linestring,geometry point,integer position);...st_asewkt-LINESTRING(0 0,0 1,1 2)(1 row)
如果输入的Geometry对象是封闭的,则返回true。语法 boolean ST_IsClosed(geometry g);参数 参数名称 描述 g 目标...st_isclosed-f(1 row)闭合的对象:SELECT ST_IsClosed('LINESTRING(0 0,0 1,1 0,0 0)':geometry);st_isclosed-t(1 row)
返回包含指定Geometry对象的最小旋转矩形。语法 geometry ST_...示例 最小旋转矩形和原始对象对比:select ST_OrientedEnvelope(g),g from(select 'POLYGON((0 0,1 0,1 1,0 1,0 0),(3 3,4 3,4 4,3 4,3 3))':geometry as g)as t;
将给meshgeom和sfmesh对象按指定的弧度进行旋转。...MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 1,-7.07106781186547 7.07106781186548 2,0 14.142135623731 3,7.07106781186548 7.07106781186547 4),INDEX((0,1,2),(1,2,3)))))
返回包含所有Geometry对象的最小的凸包。语法 geometry ST_ConvexHull(geometry ...示例 原始图形和其凸包对比:SELECT ST_ConvexHull(g),g from(select 'MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((0 6,6 3,6 6,0 6)))':geometry as g)as test
根据输入对象的顶点返回一个Delaunay三角形结果。语法 geometry ST_DelaunayTriangles(geometry ...示例 默认调用:select g,ST_DelaunayTriangles(g)from(select ST_GeneratePoints('POLYGON((0 0,1 0,1 1,0 1,0 0))':geometry,30)as g)as t;
返回一个Geometry对象中顶点的个数,适用于任何Geometry对象。语法 integer ST_NPoints(geometry g1);参数 参数名称 描述 g1 目标Geometry对象。...示例 SELECT ST_NPoints('POLYGON((0 0,0 1,1 1,0 0))':geometry);st_npoints-4(1 row)
判断scene与meshgeom是否相交。语法 bool ST_Intersects(scene sc,meshgeom geom);参数 参数名称 描述 sc scene...示例 SELECT ST_Intersects(ST_3DSphere(1,1),'Mesh(IndexSurface(Vertex(0 0 0,1 0 0,1 1 0),Index((0,1,2))))':meshgeom);t
在不丢弃顶点的情况下,把无效的Geometry对象...示例 尝试修复自相交POLYGON对象:SELECT ST_AsText(ST_MakeValid('POLYGON((0 0,0 1,1 0,1 1,0 0))'));st_astext-MULTIPOLYGON(((0 0,0 1,0.5 0.5,0 0)),((0.5 0.5,1 1,1 0,0.5 0.5.)))(1 row)
测试给定的ST_Geometry值是否格式正确。语法 boolean ST_IsValid(geometry g);...示例 SELECT ST_IsValid('POLYGON((0 0,0 1,1 0,1 1,0 0))':geometry);NOTICE:Self-intersection at or near point 0.5 0.5 st_isvalid-f(1 row)
根据输入的Geometry对象A和B,返回对象A与对象B相交的剩余部分。语法 geometry ST_Difference(geometry geomA,geometry geomB);参数 参数名称 描述 geomA Geometry对象A。geomB Geometry对象B。...st_astext-LINESTRING(0 0,0 1)(1 row)
如果给定的Geometry对象在3D空间内相交,则返回True。语法 boolean ST_3DIntersects(geometry geomA,...示例 SELECT ST_3DIntersects('LINESTRING(0 0 0,1 1 1)':geometry,'LINESTRING(1 0 0,0 1 1)':geometry);st_3dintersects-t(1 row)
返回Geometry1上最接近Geometry2的三维点。此点也是Geometry1和...示例 默认调用:SELECT ST_AsText(ST_3DClosestPoint('LINESTRING(0 0 0,1 1 1)':geometry,'LINESTRING(0 0 1,1 1 0)':geometry));st_astext-POINT Z(0.5 0.5 0.5)(1 row)