几何函数和操作符-华为云

数智融合计算服务 DATAARTSFABRIC-几何类型转换函数:polygon(npts, circle)

polygon(npts, circle) 描述：圆转换成npts点多边形。返回类型：polygon 示例： 1 2 3 4 5 6 SELECT polygon(12, circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1)) (1 row)

数智融合计算服务 DATAARTSFABRIC 几何函数和操作符

数智融合计算服务 DATAARTSFABRIC-几何类型转换函数:polygon(circle)

polygon(circle) 描述：圆转换成12点多边形。返回类型：polygon 示例： 1 2 3 4 5 6 SELECT polygon(circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1)) (1 row)

数智融合计算服务 DATAARTSFABRIC 几何函数和操作符

数智融合计算服务 DATAARTSFABRIC-几何类型转换函数:box(circle)

box(circle) 描述：将圆转换成矩形。返回类型：box 示例： 1 2 3 4 5 SELECT box(circle '((0,0),2.0)') AS RESULT; result --------------------------------------------------------------------------- (1.41421356237309,1.41421356237309),(-1.41421356237309,-1.41421356237309) (1 row)

数智融合计算服务 DATAARTSFABRIC 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:polygon(circle)

polygon(circle) 描述：圆转换成12点多边形。返回类型：polygon 示例： 1 2 3 4 5 6 gaussdb=# SELECT polygon(circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1)) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:polygon(npts, circle)

polygon(npts, circle) 描述：圆转换成npts点多边形。返回类型：polygon 示例： 1 2 3 4 5 6 gaussdb=# SELECT polygon(12, circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1)) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:polygon(box)

polygon(box) 描述：矩形转换成4点多边形。返回类型：polygon 示例： 1 2 3 4 5 gaussdb=# SELECT polygon(box '((0,0),(1,1))') AS RESULT; result --------------------------- ((0,0),(0,1),(1,1),(1,0)) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:box(circle)

box(circle) 描述：将圆转换成矩形。返回类型：box 示例： 1 2 3 4 5 gaussdb=# SELECT box(circle '((0,0),2.0)') AS RESULT; result --------------------------------------------------------------------------- (1.41421356237309,1.41421356237309),(-1.41421356237309,-1.41421356237309) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:polygon(box)

polygon(box) 描述：矩形转换成4点多边形。返回类型：polygon 示例： 1 2 3 4 5 gaussdb=# SELECT polygon(box '((0,0),(1,1))') AS RESULT; result --------------------------- ((0,0),(0,1),(1,1),(1,0)) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:polygon(circle)

polygon(circle) 描述：圆转换成12点多边形。返回类型：polygon 示例： 1 2 3 4 5 6 gaussdb=# SELECT polygon(circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1)) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:box(circle)

box(circle) 描述：将圆转换成矩形。返回类型：box 示例： 1 2 3 4 5 gaussdb=# SELECT box(circle '((0,0),2.0)') AS RESULT; result --------------------------------------------------------------------------- (1.41421356237309,1.41421356237309),(-1.41421356237309,-1.41421356237309) (1 row)

云数据库 GAUSSDB 几何函数和操作符

云数据库 GAUSSDB-几何类型转换函数:polygon(npts, circle)

polygon(npts, circle) 描述：圆转换成npts点多边形。返回类型：polygon 示例： 1 2 3 4 5 6 gaussdb=# SELECT polygon(12, circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1)) (1 row)

云数据库 GAUSSDB 几何函数和操作符

数据仓库服务 GaussDB(DWS)-几何类型转换函数:box(circle)

box(circle) 描述：将圆转换成矩形。返回类型：box 示例： 12345 SELECT box(circle '((0,0),2.0)') AS RESULT; result --------------------------------------------------------------------------- (1.41421356237309,1.41421356237309),(-1.41421356237309,-1.41421356237309)(1 row)

数据仓库服务 GaussDB(DWS) 几何函数和操作符

数据仓库服务 GaussDB(DWS)-几何类型转换函数:polygon(circle)

polygon(circle) 描述：圆转换成12点多边形。返回类型：polygon 示例： 123456 SELECT polygon(circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1))(1 row)

数据仓库服务 GaussDB(DWS) 几何函数和操作符

数据仓库服务 GaussDB(DWS)-几何类型转换函数:polygon(npts, circle)

polygon(npts, circle) 描述：圆转换成npts点多边形。返回类型：polygon 示例： 123456 SELECT polygon(12, circle '((0,0),2.0)') AS RESULT; result ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ((-2,0),(-1.73205080756888,1),(-1,1.73205080756888),(-1.22464679914735e-16,2),(1,1.73205080756888),(1.73205080756888,1),(2,2.44929359829471e-16),(1.73205080756888,-0.999999999999999),(1,-1.73205080756888),(3.67394039744206e-16,-2),(-0.999999999999999,-1.73205080756888),(-1.73205080756888,-1))(1 row)

数据仓库服务 GaussDB(DWS) 几何函数和操作符

云服务器内容精选

几何函数和操作符