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;2 ...
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;...
[{"children":[1,2],"id":100 },{"primitive":0 },{"primitive":1,"matrix":[2,0,0,1,0,2,0,3,0,0,2,4,0,0,0,1],"id":10 }],"materials":[{"type":"db","attributes":{"schema":"public","table":"t_material","column":"the_material",...
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;...
获得raster对象的UUID(通用唯一识别码)。语法 text ST_RasterID(raster raster_obj);参数 参数名称 描述 raster_obj raster...—————————————————————————————————— 4e692ed0-74e2-42a3-a10d-c28d4ae31982
快速弹性 如上所述,借助于计算与存储分离的架构,PolarDB增加一个计算节点只需要5分钟即可投入使用,从4核升级到88核的配置,只需要10分钟。自动弹性 PolarDB PostgreSQL版(兼容Oracle)提供了自动弹性伸缩的能力,用户只需配置一个基于...
update raster_table set rast=st_setvalue(rast,ST_geomfromtext('MULTIPOINT(0 0,2 2,10 10)',4326),250.0,0,true);update raster_table set rast=st_setvalue(rast,ST_geomfromtext('LINESTRING(211 77,233 100)',4326),10.0,0,false,'{...
MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,-0.894427190999916 0 1.78885438199983,-0.447213595499958.SELECT ST_AsText(ST_3DBuffer('LINESTRING(1 2 3,0 0 4)',0.5,false));MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(1.43294188107951 1...
TINYINT TINYINT NUMBER(3,0)TINYINT SMALLINT SMALLINT NUMBER(5,0)SMALLINT INT INT NUMBER(7,0)MEDIUMINT INT INT NUMBER(10,0)INT BIGINT BIGINT NUMBER(20,0)BIGINT FLOAT FLOAT BINARY_FLOAT 说明 Oracle自10g开始有此类型。...
8GB ppas.x8.medium.2 2核 16GB polar.o.x4.large 4核 16GB ppas.x4.large.2 4核 16GB polar.o.x4.large 4核 16GB ppas.x8.large.2 4核 32GB polar.o.x4.xlarge 8核 32GB ppas.x4.xlarge.2 8核 32GB polar.o.x4.xlarge 8核 32GB ppas.x8....
min|max|mean|sum|count|std|median|mode|percentile 0|2|0.16|4|25|0.5425863986500215|0|0|{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,...
返回输入Geometry对象边界框Z坐标的最小值。语法 float ST_ZMin(box3d aGeomorBox2DorBox3D);参数 参数名称 描述 aGeomorBox2DorBox3D Box2d对象、Box...示例 默认调用:SELECT ST_ZMin('LINESTRING(0 1 2,3 4 5)':geometry);st_zmin-2(1 row)
返回输入Geometry对象边界框Z坐标的最大值。语法 float ST_ZMax(box3d aGeomorBox2DorBox3D);参数 参数名称 描述 aGeomorBox2DorBox3D Box2d对象、Box...示例 默认调用:SELECT ST_ZMax('LINESTRING(0 1 2,3 4 5)':geometry);st_zmax-5(1 row)
Oracle 10g collect_10g[.sh|.bat]-h-u-p-d<service_name>Oracle 11g Oracle 11g R1 collect_11gR1[.sh|.bat]-h-u-p-d<service_name>Oracle 11g R2 collect_11gR2[.sh|.bat]-h-u-p-d<service_name>Oracle 12c 18c 19c 说明 针对Oracle 12c...
计算三维闭合模型的体积。语法 float8 ST_Volume(meshgeom geom);...示例 select ST_Volume('MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,10 0 0,0 0 0),TRIANGLE Z(0 0 0,0 10 0,10 0 0)))':mesh);166.666666666667
示例 select ST_AsEWKT(ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX(...
示例 select ST_AsEWKT(ST_MeshGeomFromWKT('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0...
示例 示例一:select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);1 示例二:select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,...
返回坐标点总数量。语法 int4 ST_NPoints(meshgeom geom);int4 ST_NPoints(sfmesh sfmeshObject);...示例 select ST_NPoints('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);4
abbrev(cidr)192.168.100.128/25 192.168.100.128/25 192.168.100.128/25 192.168/24 192.168.0.0/24 192.168.0/24 192.168/25 192.168.0.0/25 192.168.0.0/25...0.0/16 10.1/16 10 10.0.0.0/8 10/8 10.1.2.3/32 10.1.2.3/32 10.1.2.3/32 2001...
前提条件 ODC PL 支持现状 功能 支持的对象 支持的数据源 支持版本 编译 函数/存储过程/程序包 OceanBase Oracle、OB Cloud Oracle V2.2.7x、V3.0.0 及之后版本。调试 函数/存储过程/匿名块 OceanBase Oracle V3.2.3 及之后版本。运行 函数...
示例 select ST_AsEWKT(ST_MeshGeomFromBinary(ST_AsBinary('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1...
示例 select ST_AsEWKT(ST_MeshGeomFromWKB(ST_AsWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10...
ADAM的SQL转换工具可以将Oracle、Teradata、Db2语句转化为MySQL、PolarDB O引擎、云原生数据仓库 AnalyticDB PostgreSQL 版、RDS PostgreSQL、RDS PPAS、PolarDB-X语句。操作步骤 登录 数据管理DMS 5.0。在顶部菜单栏中,选择 集成与开发...
返回meshgeom或sfmesh对象构成的面的数量。语法 int4 ST_NumPatches(meshgeom geom);...示例 select ST_NumPatches('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);2
使用说明 使用前准备 内核版本 PolarDB PostgreSQL版(兼容Oracle)内核版本建议升级至20211231或以上的版本。执行以下命令,查看当前内核版本:show polar_release_date;显示结果如下所示,表示当前使用的内核版本为20211231。polar_...
使用说明 使用前准备 内核版本 PolarDB PostgreSQL版(兼容Oracle)内核版本建议升级至20211231或以上的版本。执行以下命令,查看当前内核版本:show polar_release_date;显示结果如下所示,表示当前使用的内核版本为20211231。polar_...
返回对象空间参考ID信息。语法 int4 ST_Srid(meshgeom geom);int4 ST_Srid(sfmesh sfmeshObject);参数 参数名称 描述 geom meshgeom...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'));4490
设置对象空间参考ID信息。语法 meshgeom ST_Srid(meshgeom geom,int4 srid);sfmesh ST_Srid(sfmesh sfmeshObject,int4 srid);...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'),4326));4326
MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0,0-10,-10-10,-10 0),INDEX((0,1,2),(1,2,3)))))-float array select ST_asText(ST_Affine('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0,0 10,10 10,10 0),INDEX((0,1,2),(1,2,3)))))':meshgeom,ARRAY...
返回给定Geometry对象的三维周长。语法 float ST_3DPerimeter(geometry geomA);...示例 默认调用:SELECT ST_3DPerimeter('POLYGON((0 0 0,0 2 0,2 2 2,2 0 2,0 0 0))':geometry);st_3dperimeter-9.65685424949238(1 row)
示例 SELECT ST_AsText(ST_Loft('POLYGON((0 0,1 0,1 1,0 0),(0.5 0.5,0.6 0.5,0.6 0.6,0.5 0.5))','LINESTRING(0 0 0,10 0 0,10 10 0,10 10 10)',5));MESHGEOM(PATCH(POLYGON Z((0-0.333333333333333 0.666666666666667,0 0....
st_astext-LINESTRING(1 0,2 0,0 2,1 0)(1 row)有洞的POLYGON的边界返回MULTILINESTRING:SELECT ST_AsText(ST_Boundary('POLYGON((1 0,3 0,0 3,1 0),(1 0,2 0,0 2,1 0))':geometry));st_astext-MULTILINESTRING((1 0,3 0,0 3,1 0),(1 0,2 ...
返回对象占用的内存大小。语法 int4 ST_Memsize(meshgeom geom);int4 ST_Memsize(sfmesh sfmeshObject);...示例 select st_memsize('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0,0 10,10 10,10 0),INDEX((0,1,2),(1,2,3)))))':meshgeom);144
深度值可以为以下值之一:0,1,2,4,8,16,32,64。其中,0为像素深度未知。语法 integer ST_CellDepth(raster raster_obj);参数 参数名称 描述 raster_obj raster对象。示例 select ST_CellDepth(raster_obj)from raster_table;8
返回维度信息。语法 int4 ST_Dimension(meshgeom geom);int4 ST_Dimension(sfmesh sfmeshObject);...示例 select ST_Dimension('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0,0 10,10 10,10 0),INDEX((0,1,2),(1,2,3)))))':meshgeom);2
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)...
返回给定Geometry对象的X3D表示。语法 text ST_AsX3D(geometry g1,integer maxdecimaldigits,integer options);...st_asx3d-<IndexedFaceSet convex='false' coordIndex='0 1 2 3'><Coordinate point='1 10 1 2 0 2 2 0 2 1 0 '/>(1 row)
datahub-ogg-plugin 源端 目标端 支持数据库版本 2.0.2 OGG 12.1.x.x(推荐 12.1.2.1)OGG Adapters 12.1.2.1 ORA11g 2.0.3 OGG 12.2.x.x(推荐12.2.0.2)OGG Adapters 12.2.0.1 ORA11g 2.0.4 OGG 12.2.x.x(推荐12.2.0.2)OGG Adapters 12...
CREATE TABLE emp(empno NUMBER(4),ename VARCHAR2(10),job VARCHAR2(9),mgr NUMBER(4),hiredate DATE,sal NUMBER(7,2),comm NUMBER(7,2),deptno NUMBER(2));您可以使用换行符将此内容输入到 PSQL 中。PSQL 将识别此命令直到分号才终止。...