yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
sgode-patch-2
doc-exports/docs/dws/dev/dws_04_0305.html
luhuayi 177cd61a57 DWS DEVG 910.211 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: luhuayi <luhuayi@huawei.com>
Co-committed-by: luhuayi <luhuayi@huawei.com>
2025-05-05 07:44:03 +00:00

670 lines
66 KiB
HTML
Raw Permalink Blame History

<a name="EN-US_TOPIC_0000001764491596"></a><a name="EN-US_TOPIC_0000001764491596"></a>
<h1 class="topictitle1">PostGIS Support and Constraints</h1>
<div id="body1531707297510"><div class="section" id="EN-US_TOPIC_0000001764491596__section59521232327"><h4 class="sectiontitle">Supported Data Types</h4><p id="EN-US_TOPIC_0000001764491596__p38539218315">In <span id="EN-US_TOPIC_0000001764491596__text224625133">GaussDB(DWS)</span>, PostGIS Extension support the following data types:</p>
<ul id="EN-US_TOPIC_0000001764491596__ul1742517109523"><li id="EN-US_TOPIC_0000001764491596__li154256100522">box2d</li><li id="EN-US_TOPIC_0000001764491596__li5311420115211">box3d</li><li id="EN-US_TOPIC_0000001764491596__li1151416510220">geometry_dump</li><li id="EN-US_TOPIC_0000001764491596__li163701925205210">geometry</li><li id="EN-US_TOPIC_0000001764491596__li523173019522">geography</li><li id="EN-US_TOPIC_0000001764491596__li18920943202516">raster</li></ul>
</div>
<div class="note" id="EN-US_TOPIC_0000001764491596__note1490882615165"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><div class="p" id="EN-US_TOPIC_0000001764491596__p7896195391815">If PostGIS is used by a user other than the creator of the PostGIS, set the following GUC parameters:<pre class="screen" id="EN-US_TOPIC_0000001764491596__screen82182565257">SET behavior_compat_options = 'bind_procedure_searchpath';</pre>
</div>
</div></div>
<div class="section" id="EN-US_TOPIC_0000001764491596__section1198813519310"><h4 class="sectiontitle">Supported Operators and Functions</h4><div class="note" id="EN-US_TOPIC_0000001764491596__note12568201011335"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000001764491596__p5568201017334">The <strong id="EN-US_TOPIC_0000001764491596__b11621102511819">ST_Intersects</strong> function in PostGIS uses a caching strategy that enables a high cache hit ratio for the spatial data structures of foreign tables. When there is a significant disparity in the width between the inner and foreign tables, caching the wide table's data avoid the repeated loading of large objects, leading to significant performance enhancements. Practically, leveraging <a href="dws_04_0456.html">Join Order Hints</a> to designate a wide table as the foreign table ensures that the execution plan is optimized for such scenarios.</p>
</div></div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491596__table18970162111535" frame="border" border="1" rules="all"><caption><b>Table 1 </b><strong id="EN-US_TOPIC_0000001764491596__b6824912112710">Operators and functions supported by PostGIS2.4.2</strong></caption><thead align="left"><tr id="EN-US_TOPIC_0000001764491596__row99711021145319"><th align="left" class="cellrowborder" valign="top" width="24%" id="mcps1.3.3.3.2.3.1.1"><p id="EN-US_TOPIC_0000001764491596__p149718214536">Category</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="76%" id="mcps1.3.3.3.2.3.1.2"><p id="EN-US_TOPIC_0000001764491596__p1897112175318">Function</p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001764491596__row14971152165319"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p203181644115312">Management functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p497162116533">AddGeometryColumn, DropGeometryColumn, DropGeometryTable, PostGIS_Full_Version, PostGIS_GEOS_Version, PostGIS_Liblwgeom_Version, PostGIS_Lib_Build_Date, PostGIS_Lib_Version, PostGIS_PROJ_Version, PostGIS_Scripts_Build_Date, PostGIS_Scripts_Installed, PostGIS_Version, PostGIS_LibXML_Version, PostGIS_Scripts_Released, Populate_Geometry_Columns, UpdateGeometrySRID</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1797192135316"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1055125895312">Geometry constructors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p7971321155318">ST_BdPolyFromText, ST_BdMPolyFromText, ST_Box2dFromGeoHash, ST_GeogFromText, ST_GeographyFromText, ST_GeogFromWKB, ST_GeomCollFromText, ST_GeomFromEWKB, ST_GeomFromEWKT, ST_GeometryFromText, ST_GeomFromGeoHash, ST_GeomFromGML, ST_GeomFromGeoJSON, ST_GeomFromKML, ST_GMLToSQL, ST_GeomFromText, ST_GeomFromWKB, ST_LineFromMultiPoint, ST_LineFromText, ST_LineFromWKB, ST_LinestringFromWKB, ST_MakeBox2D, ST_3DMakeBox, ST_MakeEnvelope, ST_MakePolygon, ST_MakePoint, ST_MakePointM, ST_MLineFromText, ST_MPointFromText, ST_MPolyFromText, ST_Point, ST_PointFromGeoHash, ST_PointFromText, ST_PointFromWKB, ST_Polygon, ST_PolygonFromText, ST_WKBToSQL, ST_WKTToSQL</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row297113213531"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p749821415413">Geometry accessors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p697142115532">GeometryType, ST_Boundary, ST_CoordDim, ST_Dimension, ST_EndPoint, ST_Envelope, ST_ExteriorRing, ST_GeometryN, ST_GeometryType, ST_InteriorRingN, ST_IsClosed, ST_IsCollection, ST_IsEmpty, ST_IsRing, ST_IsSimple, ST_IsValid, ST_IsValidReason, ST_IsValidDetail, ST_M, ST_NDims, ST_NPoints, ST_NRings, ST_NumGeometries, ST_NumInteriorRings, ST_NumInteriorRing, ST_NumPatches, ST_NumPoints, ST_PatchN, ST_PointN, ST_SRID, ST_StartPoint, ST_Summary, ST_X, ST_XMax, ST_XMin, ST_Y, ST_YMax, ST_YMin, ST_Z, ST_ZMax, ST_Zmflag, ST_ZMin</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1997102165319"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p796118260543">Geometry editors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1097115214532">ST_AddPoint, ST_Affine, ST_Force2D, ST_Force3D, ST_Force3DZ, ST_Force3DM, ST_Force4D, ST_ForceCollection, ST_ForceSFS, ST_ForceRHR, ST_LineMerge, ST_CollectionExtract, ST_CollectionHomogenize, ST_Multi, ST_RemovePoint, ST_Reverse, ST_Rotate, ST_RotateX, ST_RotateY, ST_RotateZ, ST_Scale, ST_Segmentize, ST_SetPoint, ST_SetSRID, ST_SnapToGrid, ST_Snap, ST_Transform, ST_Translate, ST_TransScale</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1297132115534"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p3121194017543">Geometry outputs</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p197132120536">ST_AsBinary, ST_AsEWKB, ST_AsEWKT, ST_AsGeoJSON, ST_AsGML, ST_AsHEXEWKB, ST_AsKML, ST_AsLatLonText, ST_AsSVG, ST_AsText, ST_AsX3D, ST_GeoHash</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row19971182117536"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p41350135414">Operators</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><pre class="codeblock" id="EN-US_TOPIC_0000001764491596__codeblock137719503558">&amp;&amp;, &amp;&amp;&amp;, &amp;&lt;, &amp;&lt;|, &amp;&gt;, &lt;&lt;, &lt;&lt;|, =, &gt;&gt;, @, |&amp;&gt;, |&gt;&gt;, ~, ~=, &lt;-&gt;, &lt;#&gt;</pre>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row12971182115314"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p149711221175319">Spatial relationships and measurements</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p6971421155314">ST_3DClosestPoint, ST_3DDistance, ST_3DDWithin, ST_3DDFullyWithin, ST_3DIntersects, ST_3DLongestLine, ST_3DMaxDistance, ST_3DShortestLine, ST_Area, ST_Azimuth, ST_Centroid, ST_ClosestPoint, ST_Contains, ST_ContainsProperly, ST_Covers, ST_CoveredBy, ST_Crosses, ST_LineCrossingDirection, ST_Disjoint, ST_Distance, ST_HausdorffDistance, ST_MaxDistance, ST_DistanceSphere, ST_DistanceSpheroid, ST_DFullyWithin, ST_DWithin, ST_Equals, ST_HasArc, ST_Intersects, ST_Length, ST_Length2D, ST_3DLength, ST_Length_Spheroid, ST_Length2D_Spheroid, ST_3DLength_Spheroid, ST_LongestLine, ST_OrderingEquals, ST_Overlaps, ST_Perimeter, ST_Perimeter2D, ST_3DPerimeter, ST_PointOnSurface, ST_Project, ST_Relate, ST_RelateMatch, ST_ShortestLine, ST_Touches, ST_Within</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row2971112115316"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p620562615557">Geometry processing</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p15971421115310">ST_Buffer, ST_BuildArea, ST_Collect, ST_ConcaveHull, ST_ConvexHull, ST_CurveToLine, ST_DelaunayTriangles, ST_Difference, ST_Dump, ST_DumpPoints, ST_DumpRings, ST_FlipCoordinates, ST_Intersection, ST_LineToCurve, ST_MakeValid, ST_MemUnion, ST_MinimumBoundingCircle, ST_Polygonize, ST_Node, ST_OffsetCurve, ST_RemoveRepeatedPoints, ST_SharedPaths, ST_Shift_Longitude, ST_Simplify, ST_SimplifyPreserveTopology, ST_Split, ST_SymDifference, ST_Union, ST_UnaryUnion</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row697122195317"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1511184455511">Linear referencing</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p9971921165313">ST_LineInterpolatePoint, ST_LineLocatePoint, ST_LineSubstring, ST_LocateAlong, ST_LocateBetween, ST_LocateBetweenElevations, ST_InterpolatePoint, ST_AddMeasure</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row2971172165312"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1397118218530">Miscellaneous functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1697182135318">ST_Accum, Box2D, Box3D, ST_Expand, ST_Extent, ST_3Dextent, Find_SRID, ST_MemSize</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row6971721205312"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p797162111538">Exceptional functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p5971102115535">PostGIS_AddBBox, PostGIS_DropBBox, PostGIS_HasBBox</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row109631416182815"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p19641016192819">Raster Management Functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p19964161682818">AddRasterConstraints, DropRasterConstraints, AddOverviewConstraints, DropOverviewConstraints, PostGIS_GDAL_Version, PostGIS_Raster_Lib_Build_Date, PostGIS_Raster_Lib_Version, and ST_GDALDrivers, and UpdateRasterSRID</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1721062613413"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p12210192693420">Raster Constructors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p102101126123416">ST_AddBand, ST_AsRaster, ST_Band, ST_MakeEmptyRaster, ST_Tile, and ST_FromGDALRaster</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1810571383617"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1210515139360">Raster Accessors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p21051713173612">ST_GeoReference, ST_Height, ST_IsEmpty, ST_MetaData, ST_NumBands, ST_PixelHeight, ST_PixelWidth, ST_ScaleX, ST_ScaleY, ST_RasterToWorldCoord, ST_RasterToWorldCoordX, ST_RasterToWorldCoordY, ST_Rotation, ST_SkewX, ST_SkewY, ST_SRID, ST_Summary, ST_UpperLeftX, ST_UpperLeftY, ST_Width, ST_WorldToRasterCoord, ST_WorldToRasterCoordX, ST_WorldToRasterCoordY</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row204871147114014"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1248884720409">Raster Band Accessors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p848816471408">ST_BandMetaData, ST_BandNoDataValue, ST_BandIsNoData, ST_BandPath, ST_BandPixelType, and ST_HasNoBand</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row153852085427"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p7386789424">Raster Pixel Accessors and Setters</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p15386178134218">ST_PixelAsPolygon, ST_PixelAsPolygons, ST_PixelAsPoint, ST_PixelAsPoints, ST_PixelAsCentroid, ST_PixelAsCentroids, ST_Value, ST_NearestValue, ST_Neighborhood, ST_SetValue, ST_SetValues, ST_DumpValues, and ST_PixelOfValue</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row18775152444"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p17775559441">Raster Editors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p677520513445">ST_SetGeoReference, ST_SetRotation, ST_SetScale, ST_SetSkew, ST_SetSRID, ST_SetUpperLeft, ST_Resample, ST_Rescale, ST_Reskew, and ST_SnapToGrid, ST_Resize, and ST_Transform</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row58743257463"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p187412594614">Raster Band Editors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1187510255462">ST_SetBandNoDataValue and ST_SetBandIsNoData</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row16494144744618"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p3494447164616">Raster Band Statistics and Analytics</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p4494184764612">ST_Count, ST_CountAgg, ST_Histogram, ST_Quantile, ST_SummaryStats, ST_SummaryStatsAgg, and ST_ValueCount</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row16657191516488"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1657715114817">Raster Outputs</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p265771564811">ST_AsBinary, ST_AsGDALRaster, ST_AsJPEG, ST_AsPNG, and ST_AsTIFF</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row188331196497"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p198333914490">Raster Processing</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p198344924920">ST_Clip, ST_ColorMap, ST_Intersection, ST_MapAlgebra, ST_Reclass, and ST_Union ST_Distinct4ma, ST_InvDistWeight4ma, ST_Max4ma, ST_Mean4ma, ST_Min4ma, ST_MinDist4ma, ST_Range4ma, ST_StdDev4ma, and ST _Sum4ma, ST_Aspect, ST_HillShade, ST_Roughness, ST_Slope, ST_TPI, ST_TRI, Box3D, ST_ConvexHull, ST_DumpAsPolygons, and ST_ Envelope, ST_MinConvexHull, ST_Polygon, ST_Contains, ST_ContainsProperly, ST_Covers, ST_CoveredBy, ST_Disjoint, ST_Intersects, and ST_Overlaps, ST_Touches, ST_SameAlignment, ST_NotSameAlignmentReason, ST_Within, ST_DWithin, and ST_DFullyWithin</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row255131410207"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.3.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1571514142010">Raster Operators</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.3.2.3.1.2 "><pre class="codeblock" id="EN-US_TOPIC_0000001764491596__codeblock14321131895515">&amp;&amp;, &amp;&lt;, &amp;&gt;, =, @, ~=, and ~</pre>
</td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491596__table17116322298" frame="border" border="1" rules="all"><caption><b>Table 2 </b><strong id="EN-US_TOPIC_0000001764491596__b1821842482716">Operators and functions supported by PostGIS3.2.2</strong></caption><thead align="left"><tr id="EN-US_TOPIC_0000001764491596__row51169217294"><th align="left" class="cellrowborder" valign="top" width="24%" id="mcps1.3.3.4.2.3.1.1"><p id="EN-US_TOPIC_0000001764491596__p1511615252918">Category</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="76%" id="mcps1.3.3.4.2.3.1.2"><p id="EN-US_TOPIC_0000001764491596__p2011716210290">Function</p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001764491596__row711732102919"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p611718292915">Management functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p6117102192920">AddGeometryColumn, DropGeometryColumn, DropGeometryTable, PostGIS_Full_Version, PostGIS_GEOS_Version, PostGIS_Liblwgeom_Version, PostGIS_Lib_Build_Date, PostGIS_Lib_Version, PostGIS_PROJ_Version, PostGIS_Scripts_Build_Date, PostGIS_Scripts_Installed, PostGIS_Version, PostGIS_LibXML_Version, PostGIS_Scripts_Released, Populate_Geometry_Columns, UpdateGeometrySRID, PostGIS_Libprotobuf_Version, PostGIS_Wagyu_Version</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row151174213298"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p61171628293">Geometry constructors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p2117172122911">ST_BdPolyFromText, ST_BdMPolyFromText, ST_Box2dFromGeoHash, ST_GeneratePoints, ST_GeogFromText, ST_GeographyFromText, ST_GeogFromWKB, ST_GeomCollFromText, ST_GeomFromEWKB, ST_GeomFromEWKT, ST_GeometryFromText, ST_GeomFromGeoHash, ST_GeomFromGML, ST_GeomFromGeoJSON, ST_GeomFromKML, ST_GMLToSQL, ST_GeomFromText, ST_GeomFromWKB, ST_LineFromMultiPoint, ST_LineFromText, ST_LineFromWKB, ST_LinestringFromWKB, ST_MakeBox2D, ST_3DMakeBox, ST_MakeEnvelope, ST_MakePolygon, ST_MakePoint, ST_MakePointM, ST_MLineFromText, ST_MPointFromText, ST_MPolyFromText, ST_Point, ST_Points, ST_PointFromGeoHash, ST_PointFromText, ST_PointFromWKB, ST_Polygon, ST_PolygonFromText, ST_WKBToSQL, ST_WKTToSQL, Geography_Distance_Knn, Geometry_Distance_Cpa, Geometry_Hash, ST_3Dlineinterpolate, ST_AsEncodedPolyline</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row21172216292"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p13117129295">Geometry accessors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p11117522293">GeometryType, ST_Boundary, ST_CoordDim, ST_Dimension, ST_EndPoint, ST_Envelope, ST_ExteriorRing, ST_GeometryN, ST_GeometryType, ST_InteriorRingN, ST_IsClosed, ST_IsCollection, ST_IsEmpty, ST_IsPolygonCCW, ST_IsPolygonCW, ST_IsRing, ST_IsSimple, ST_IsValid, ST_IsValidReason, ST_IsValidDetail, ST_M, ST_NDims, ST_NPoints, ST_NRings, ST_NumGeometries, ST_NumInteriorRings, ST_NumInteriorRing, ST_NumPatches, ST_NumPoints, ST_PatchN, ST_PointN, ST_SRID, ST_StartPoint, ST_Summary, ST_X, ST_XMax, ST_XMin, ST_Y, ST_YMax, ST_YMin, ST_Z, ST_ZMax, ST_Zmflag, ST_ZMin, ST_Wrapx, ST_Asmvt</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row51171923291"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p511782122917">Geometry editors</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p16422161517596">ST_AddPoint, ST_Affine, ST_Force2D, ST_Force3D, ST_Force3DZ, ST_Force3DM, ST_Force4D, ST_ForceCollection, ST_ForcePolygonCCW, ST_ForcePolygonCW, ST_ForceSFS, ST_ForceRHR, ST_LineMerge, ST_CollectionExtract, ST_CollectionHomogenize, ST_Multi, ST_Normalize, ST_RemovePoint, ST_Reverse, ST_Rotate, ST_RotateX, ST_RotateY, ST_RotateZ, ST_Scale, ST_Segmentize, ST_SetPoint, ST_SetSRID, ST_SnapToGrid, ST_Snap, ST_Transform, ST_Translate, ST_TransScale, ST_AsmvtGeom, ST_isvalidTrajectory, ST_linefromencodedpolyline, ST_lineinterpolatepoints, ST_MaximuminScribedCircle, ST_OrientedEnvelope, ST_QuantizeCoordinates, ST_ReducePrecision, ST_Scroll, ST_SetEffectiveArea, ST_simplifyvw, ST_square, ST_squaregrid, ST_Swapordinates, ST_Voronoilines, ST_VoronoiPolygons</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row17117824298"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p81175213297">Geometry outputs</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p6117162102919">ST_AsBinary, ST_AsEWKB, ST_AsEWKT, ST_AsGeoJSON, ST_AsGML, ST_AsHEXEWKB, ST_AsKML, ST_AsLatLonText , ST_AsSVG, ST_AsText, ST_AsTwkb, ST_AsX3D, ST_GeoHash, Json, Jsonb, ST_GeomfromGeojson</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row611718218293"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p11117425290">Operators</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><pre class="codeblock" id="EN-US_TOPIC_0000001764491596__codeblock383916265613">&amp;&amp; , &amp;&amp;&amp; , &amp;&lt; , &amp;&lt;|, &amp;&gt; , &lt;&lt; , &lt;&lt;|, =, &gt;&gt; , @ , |&amp;&gt; , |&gt;&gt; , ~, ~=, &lt;-&gt; , &lt;#&gt; , &lt;-&gt; , |=|, &lt;&lt;-&gt;&gt;</pre>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row181172222914"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p12117142112916">Spatial relationships and measurements</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1711712182917">ST_3DClosestPoint, ST_3DDistance, ST_3DDWithin, ST_3DDFullyWithin, ST_3DIntersects, ST_3DLongestLine, ST_3DMaxDistance, ST_3DShortestLine, ST_Area, ST_Azimuth, ST_Centroid, ST_ClosestPoint, ST_Contains, ST_ContainsProperly, ST_Covers, ST_CoveredBy, ST_Crosses, ST_LineCrossingDirection, ST_Disjoint, ST_Distance, ST_HausdorffDistance, ST_MaxDistance, ST_DistanceSphere, ST_DistanceSpheroid, ST_DFullyWithin, ST_DWithin, ST_Equals, ST_HasArc, ST_Intersects, ST_Length, ST_Length2D, ST_3DLength, ST_LengthSpheroid, ST_Length2DSpheroid, ST_LongestLine, ST_MinimumBoundingRadius, ST_OrderingEquals, ST_Overlaps, ST_Perimeter, ST_Perimeter2D, ST_3DPerimeter, ST_PointOnSurface, ST_Project, ST_Relate, ST_RelateMatch, ST_ShortestLine, ST_Touches, ST_Within, _ST_DistancerectTree, _ST_DistancerectTreeCached, _ST_SorTableHash</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1211710212296"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p15117126294">Geometry processing</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p611722172920">ST_Buffer, ST_BuildArea, ST_ClipByBox2D, ST_ClusterDBSCAN, ST_ClusterIntersecting, ST_ClusterKMeans, ST_ClusterWithin, ST_Collect, ST_ConcaveHull, ST_ConvexHull, ST_CurveToLine, ST_DelaunayTriangles, ST_Difference, ST_Dump, ST_DumpPoints, ST_DumpRings, ST_FlipCoordinates, ST_Intersection, ST_LineToCurve, ST_MakeValid, ST_MemUnion, ST_MinimumBoundingCircle, ST_Polygonize, ST_Node, ST_OffsetCurve, ST_RemoveRepeatedPoints, ST_SharedPaths, ST_ShiftLongitude, ST_Simplify, ST_SimplifyPreserveTopology, ST_Split, ST_Subdivide, ST_SymDifference, ST_Union, ST_UnaryUnion, ST_BoundingDiagonal, ST_ChaikinsMoothing, ST_ClosestPointofApproach, ST_CollectionExtract, ST_CPAwithin, ST_DistanceCPA, ST_DumpSegments, ST_EstimatedExtent, ST_Filterbym, ST_SetEffectiveArea, ST_Forcecurve</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1211702112919"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p811772142912">Linear referencing</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p8117152122915">ST_LineInterpolatePoint, ST_LineLocatePoint, ST_LineSubstring, ST_LocateAlong, ST_LocateBetween, ST_LocateBetweenElevations, ST_InterpolatePoint, ST_AddMeasure</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row13117152162913"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p31179282917">Miscellaneous functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p91171221293">Array_Agg, Box2D, Box3D, ST_Expand, ST_Extent, ST_3Dextent, Find_SRID, ST_MemSize</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row2011792162913"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.3.4.2.3.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1211717217294">Exceptional functions</p>
</td>
<td class="cellrowborder" valign="top" width="76%" headers="mcps1.3.3.4.2.3.1.2 "><p id="EN-US_TOPIC_0000001764491596__p21171021294">PostGIS_AddBBox, PostGIS_DropBBox, PostGIS_HasBBox</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="section" id="EN-US_TOPIC_0000001764491596__section2993751311"><h4 class="sectiontitle">Spatial Indexes</h4><p id="EN-US_TOPIC_0000001764491596__p10578174055816">In <span id="EN-US_TOPIC_0000001764491596__text2093557678">GaussDB(DWS)</span>, PostGIS Extension supports Generalized Search Tree (GIST) spatial indexes. This index type is inapplicable to partitioned tables. Different from B-tree indexes, GiST indexes are suitable for any type of unconventional data structure and can effectively improve the retrieval efficiency of geometric and geographic data.</p>
<p id="EN-US_TOPIC_0000001764491596__p48972044178">Run the following command to create a GiST index:</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001764491596__screen17652152518452"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">INDEX</span><span class="w"> </span><span class="n">indexname</span><span class="w"> </span><span class="k">ON</span><span class="w"> </span><span class="n">tablename</span><span class="w"> </span><span class="k">USING</span><span class="w"> </span><span class="n">GIST</span><span class="w"> </span><span class="p">(</span><span class="w"> </span><span class="n">geometryfield</span><span class="w"> </span><span class="p">);</span>
</pre></div></td></tr></table></div>
</div>
</div>
<div class="section" id="EN-US_TOPIC_0000001764491596__section13902113312416"><h4 class="sectiontitle">Extension Constraints</h4><ul id="EN-US_TOPIC_0000001764491596__ul17771948131018"><li id="EN-US_TOPIC_0000001764491596__li16771548131016">Only row-store tables are supported. Column-store indexes are not supported.</li><li id="EN-US_TOPIC_0000001764491596__li541594174118">Only Oracle-compatible databases are supported.</li><li id="EN-US_TOPIC_0000001764491596__li07317558101">The topology object management module, Topology, is not supported.</li><li id="EN-US_TOPIC_0000001764491596__li14818417110">BRIN indexes are not supported.</li><li id="EN-US_TOPIC_0000001764491596__li1117511305615">The <strong id="EN-US_TOPIC_0000001764491596__b2933181714339">spatial_ref_sys</strong> table can only be queried during scale-out.</li></ul>
</div>
<div class="section" id="EN-US_TOPIC_0000001764491596__section880143416295"><h4 class="sectiontitle">Plug-in Upgrade Compatibility</h4><p id="EN-US_TOPIC_0000001764491596__p5124101845115">When upgrading from PostGIS 2.4.2 to 3.2.2, note that certain functions may become incompatible or not fully forward compatible. This can lead to inconsistencies in the functionality before and after the upgrade. Therefore, it is necessary to assess the impact of upgrade incompatibility on your services.</p>
<p id="EN-US_TOPIC_0000001764491596__p6421684515">The following table provides compatibility details for related functions.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491596__table19958195919333" frame="border" border="1" rules="all"><thead align="left"><tr id="EN-US_TOPIC_0000001764491596__row59581559203318"><th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.6.4.1.4.1.1"><p id="EN-US_TOPIC_0000001764491596__p1795818594330"><strong id="EN-US_TOPIC_0000001764491596__b10778034894">Category</strong></p>
</th>
<th align="left" class="cellrowborder" valign="top" width="35%" id="mcps1.3.6.4.1.4.1.2"><p id="EN-US_TOPIC_0000001764491596__p69588597333">PostGIS 2.4.2</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="45%" id="mcps1.3.6.4.1.4.1.3"><p id="EN-US_TOPIC_0000001764491596__p1282649163411">PostGIS 3.2.2</p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001764491596__row932620154586"><td class="cellrowborder" rowspan="26" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1914202485810">Added functions in 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p11421624135819">N/A</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p714210249589">ST_IsPolygonCW(geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row18326151545814"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p014212412587">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1142122425815">ST_IsPolygonCCW(geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row832781585820"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p6689113110584">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p668963115583">ST_PointInsideCircle(geometry,float8,float8,float8)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row5327515195814"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1530111112014">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p13301611107">ST_ForcePolygonCW(geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row878749195812"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p17302011203">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p11302411500">ST_ForcePolygonCCW(geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row678869155815"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p143021911701">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p93024111605">ST_Normalize(geom geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row52726412581"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p430281117014">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p43030117014">ST_AsTWKB(geom geometry, prec int4 default 0, prec_z int4 default 0, prec_m int4 default 0, with_sizes boolean default false, with_boxes boolean default false)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row396117535715"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1930313111502">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p18303161118011">ST_AsTWKB(geom geometry[], ids bigint[], prec int4 default 0, prec_z int4 default 0, prec_m int4 default 0, with_sizes boolean default false, with_boxes boolean default false)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row101232042175816"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p43032114015">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p930319113013">ST_MakeLine (geometry[])</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row81247429589"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p930421113012">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p193048111104">ST_TileEnvelope(zoom integer, x integer, y integer, bounds geometry DEFAULT 'SRID=3857;LINESTRING(-20037508.342789244 -20037508.342789244, 20037508.342789244 20037508.342789244)'::geometry, margin float8 DEFAULT 0.0)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row812444214588"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p193044110019">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p830410117012">ST_ClusterIntersecting(geometry[])</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row21245423588"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p830451112011">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p11304811305">ST_ClusterWithin(geometry[], float8)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row19125194285811"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p16305811309">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p153050111308">ST_ClusterDBSCAN (geometry, eps float8, minpoints int)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1262865612584"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p23054111003">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p133059111709">ST_Scale(geometry,geometry,origin geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row106281956115819"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p91363319010">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1013612312011">ST_GeneratePoints(area geometry, npoints integer, seed integer)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row5629205645815"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p181374311509">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1613783113011">ST_FrechetDistance(geom1 geometry, geom2 geometry, float8 default -1)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row136291856175813"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p11372317014">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p81374311606">ST_Points(geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row20630956125816"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1171710561020">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p18717185611011">ST_ClipByBox2d(geom geometry, box box2d)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row11630195645815"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p18718195619018">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p207183561005">ST_Subdivide(geom geometry, maxvertices integer DEFAULT 256, gridSize float8 DEFAULT -1.0)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row116303562582"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p4675141912">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p196715142117">ST_ClusterIntersecting (geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row12129537102"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p56711414117">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p156719145118">ST_ClusterWithin (geometry, float8)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row151305371409"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p19689147116">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p19681514015">ST_ClusterKMeans(geom geometry, k integer, max_radius float8 default null)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row13130237602"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p81530322117">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p171544328110">ST_AsText(geometry, int4)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1539611421108"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p13432351010">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p134329514112">ST_AsEWKT(geography, int4)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row139616421804"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1743315117119">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p194331651116">_ST_CoveredBy(geog1 geography, geog2 geography)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row12397164211018"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p617215628">N/A</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p6181815826">ST_Point(float8, float8, srid integer)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row295845953319"><td class="cellrowborder" rowspan="36" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p183063074413">Functions no longer supported in 3.2.2</p>
<p id="EN-US_TOPIC_0000001764491596__p18886173313"></p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p193063015447">ST_3DLength_spheroid(geometry, spheroid)</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p15306140144419">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row295845943316"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p169147724516">ST_length2d_spheroid(geometry, spheroid)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p991416718451">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1267591720416"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p195571901102">ST_locate_between_measures(geometry, float8, float8)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1921429208">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row72581222416"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p92092034204">ST_locate_along_measure(geometry, float8)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1720913347012">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row15990192817414"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p117733717210">ST_Buffer(geometry,float8,text)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p182461359828">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row999022811412"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p6144122532">ST_GeneratePoints(area geometry, npoints integer)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p8144521238">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row3141172512"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p189630453615">ST_Combine_BBox(box3d,geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p18963124515616">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row105911711156"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p6952834375">ST_Combine_BBox(box2d,geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p153851957778">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1731165111517"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p35512385719">pgis_abs_in(cstring)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p455183811715">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row183214519513"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p12485121110810">pgis_abs_out(pgis_abs)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p194856116815">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1176711551351"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p48125383815">pgis_abs ( internallength = 16, input = pgis_abs_in, output = pgis_abs_out, alignment = double)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p188121238289">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row376825514517"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p784617101598">ST_MemUnion(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p138461210895">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row6768255059"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p4170132117912">pgis_geometry_accum_finalfn(pgis_abs)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p57576446914">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row187685554519"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1575111471592">ST_MakeLine (geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p157511647991">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row473150569"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p0214108131013">ST_Accum (geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p16848132981015">When a single geometry data record is input, its value is output directly. However, if multiple geometry data records are provided, an error message will be displayed, indicating that multiple records are unsupported.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row17741801061"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p280695151711">_ST_AsKML(int4,geometry, int4, text)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p78062517174">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row57410161"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p4239133371414">ST_MemUnion(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p192396337141">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row27460861"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1336322211184">_ST_AsGeoJson(int4, geometry, int4, int4)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p0363192213186">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row375509611"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p19154155501913">ST_AsGeoJson(gj_version int4, geom geometry, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p10154125511913">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row67560765"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p166901233172016">_ST_DWithin(geography, geography, float8, boolean)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1690193317203">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row10758016615"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p55731225112110">ST_point_inside_circle(geometry,float8,float8,float8)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p697383982110">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1452105984"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p154471640202217">ST_CurveToLine(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1410105872217">N/A</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row19127612408"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p181311611402">ST_Shift_Longitude(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p3138694019">Use <strong id="EN-US_TOPIC_0000001764491596__b39871782115">ST_ShiftLongitude</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row20610112174216"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p961072184211">ST_find_extent(text,text,text) and ST_find_extent(text,text)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p15610121134216">Use <strong id="EN-US_TOPIC_0000001764491596__b5305534121114">ST_FindExtent</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row175718472424"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1257164774218">ST_mem_size(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1357184712427">Use <strong id="EN-US_TOPIC_0000001764491596__b1348264212116">ST_MemSize</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row15715173914418"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p14716439124412">ST_length_spheroid(geometry, spheroid)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p10716173914413">Use <strong id="EN-US_TOPIC_0000001764491596__b121691549161110">ST_LengthSpheroid</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row129914044611"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p169954010468">ST_distance_spheroid(geom1 geometry, geom2 geometry,spheroid)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p9334175184718">Use <strong id="EN-US_TOPIC_0000001764491596__b18161253122">ST_DistanceSpheroid</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row14951511144810"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p59511711154813">ST_force_2d(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p135145516488">Use <strong id="EN-US_TOPIC_0000001764491596__b1659612134123">ST_Force2D</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1477713114816"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p077753111486">ST_force_3dz(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p087485554813">Use <strong id="EN-US_TOPIC_0000001764491596__b15473190129">ST_Force3DZ</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row72151235124812"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p13215193515485">ST_force_3d(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1721515357484">Use <strong id="EN-US_TOPIC_0000001764491596__b10978427111210">ST_Force3D</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row8975181734918"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p6975151713490">ST_force_3dm(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p757612110526">Use <strong id="EN-US_TOPIC_0000001764491596__b8156351124">ST_Force3DM</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1573852164920"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1673972114497">ST_force_4d(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p18506522165219">Use <strong id="EN-US_TOPIC_0000001764491596__b1078854241211">ST_Force4D</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row945982613522"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1845952616529">ST_force_collection(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p14675644165214">Use <strong id="EN-US_TOPIC_0000001764491596__b16123135013121">ST_ForceCollection</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row968653811597"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p668643885917">ST_line_locate_point(geom1 geometry, geom2 geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p5686438155919">Use <strong id="EN-US_TOPIC_0000001764491596__b163182575121">ST_LineLocatePoint</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row693966125913"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p169391265596">ST_line_interpolate_point(geometry, float8)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p693918675915">Use <strong id="EN-US_TOPIC_0000001764491596__b434918312131">ST_LineInterpolatePoint</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row6557140002"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p2886173510">ST_Buffer(geometry,float8)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p78869313113">Use <strong id="EN-US_TOPIC_0000001764491596__b2045713133132">ST_Buffer</strong> instead.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row16842532101016"><td class="cellrowborder" rowspan="10" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p126546612326">Functions with parameter type changed in 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p15842173281019">pgis_geometry_accum_transfn(pgis_abs, geometry)</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p198421432191011">pgis_geometry_accum_transfn(internal, geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row17253100141118"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p32539010110">pgis_geometry_accum_transfn(pgis_abs, geometry, float8)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1125317011110">pgis_geometry_accum_transfn(internal, geometry, float8)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row2457313116"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p18458371112">pgis_geometry_accum_transfn(pgis_abs, geometry, float8, int)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p114520317116">pgis_geometry_accum_transfn(internal, geometry, float8, int)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1679106151110"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p3791681117">pgis_geometry_union_finalfn(pgis_abs)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p6795691117">pgis_geometry_union_finalfn(internal)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row0609951215"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p36018912120">pgis_geometry_collect_finalfn(pgis_abs)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p176010961215">pgis_geometry_collect_finalfn(internal)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row373851151217"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p673881191215">pgis_geometry_polygonize_finalfn(pgis_abs)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1673810114127">pgis_geometry_polygonize_finalfn(internal)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row6507171171312"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1950791115134">pgis_geometry_clusterintersecting_finalfn(pgis_abs)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p10507191141310">pgis_geometry_clusterintersecting_finalfn(internal)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row11918782141"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1891816811148">ST_Union (geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1491817819143">ST_Union (geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1765843618141"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p365814361142">ST_Collect (geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1165816367143">ST_Collect (geometry)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row9693945122518"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p95026812219">ST_Buffer(geometry,float8,integer)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p150388723">ST_Buffer(geom geometry, radius float8, quadsegs integer)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row17308189181718"><td class="cellrowborder" rowspan="3" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p730814910178">Functions with API changed in 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p330814914176">ST_AsKML(version int4, geom geometry, maxdecimaldigits int4 DEFAULT 15, nprefix text DEFAULT null)</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p33081397172">ST_AsKML(geom geometry, maxdecimaldigits int4 DEFAULT 15, nprefix TEXT default ' ')</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row10778115512174"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p16779135561714">ST_AsKML(geom geometry, maxdecimaldigits int4 DEFAULT 15)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1177965511710">ST_AsKML(geom geometry, maxdecimaldigits int4 DEFAULT 15, nprefix TEXT default ' ')</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row1223861918183"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p152381199187">ST_AsKML(version int4, geom geometry, maxdecimaldigits int4 DEFAULT 15, nprefix text DEFAULT null)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p923871918185">ST_AsGML(version int4, geog geography, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0, nprefix text DEFAULT 'gml', id text DEFAULT '')</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row597403610205"><td class="cellrowborder" rowspan="7" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p5608185814213">Functions with default parameters changed in 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p162117441826">ST_SymDifference(geom1 geometry, geom2 geometry)</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p18621104413218">ST_SymDifference(geom1 geometry, geom2 geometry, gridSize float8 DEFAULT -1.0)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row298993372117"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p26223441128">ST_UnaryUnion(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p136221444622">ST_UnaryUnion(geometry, gridSize float8 DEFAULT -1.0)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row217112457231"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p9974103613201">ST_AsGeoJson(geom geometry, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p19974113618206">ST_AsGeoJson(geom geometry, maxdecimaldigits int4 DEFAULT 9, options int4 DEFAULT 8)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row81734509246"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1072915221712">ST_Buffer(geometry,float8,cstring)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p6729222513">ST_Buffer(geom geometry, radius float8, options text DEFAULT ' ')</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row205958474265"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p261735313260">_ST_DWithin(geography, geography, float8, boolean)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p56171153202611">_ST_DWithin(geog1 geography, geog2 geography, tolerance float8, use_spheroid boolean DEFAULT true)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row10500937132119"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1813673110010">ST_IsValidDetail(geometry)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p1513619315018">ST_IsValidDetail(geom geometry, flags int4 DEFAULT 0)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row95411340202313"><td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p4560217182217">ST_CurveToLine(geom geometry, tol float8, toltype integer, flags integer)</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p35602175220">ST_CurveToLine(geom geometry, tol float8 DEFAULT 32, toltype integer DEFAULT 0, flags integer DEFAULT 0)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row195011037172112"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1195835953319">Functions supported <strong id="EN-US_TOPIC_0000001764491596__b199094131514">hash join</strong> and <strong id="EN-US_TOPIC_0000001764491596__b1691914317153">merge join</strong> in 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p16958145911331">OPERATOR =</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p38266973416">OPERATOR =</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row2832105210481"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p1883355210486">Function changes in version 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><p id="EN-US_TOPIC_0000001764491596__p88331152164811">ST_ConcaveHull weak verification</p>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><p id="EN-US_TOPIC_0000001764491596__p1483395234811">Strong verification is added to ST_ConcaveHull to ensure more rigorous verification.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001764491596__row17772114012114"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.6.4.1.4.1.1 "><p id="EN-US_TOPIC_0000001764491596__p129581359203312">Functions with <strong id="EN-US_TOPIC_0000001764491596__b5798747191619">commutor</strong> undefined in 3.2.2</p>
</td>
<td class="cellrowborder" valign="top" width="35%" headers="mcps1.3.6.4.1.4.1.2 "><pre class="codeblock" id="EN-US_TOPIC_0000001764491596__codeblock1227222125617">OPERATOR &amp;&lt; ,OPERATOR &amp;&lt;|,OPERATOR |&amp;&gt;</pre>
</td>
<td class="cellrowborder" valign="top" width="45%" headers="mcps1.3.6.4.1.4.1.3 "><pre class="codeblock" id="EN-US_TOPIC_0000001764491596__codeblock1976462520564">OPERATOR &amp;&lt; ,OPERATOR &amp;&lt;|,OPERATOR |&amp;&gt;</pre>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0301.html">Using PostGIS Extension</a></div>
</div>
</div>
View Git Blame Copy Permalink