FunctionSet - Набор функций sql-диалекта¶
-
class
axioma.core.sql.FunctionName¶ Идентификаторы функций
Возможные функции диалектов FunctionName:¶Тип
Значение
Название функции
FunctionAbsent0
Отсутствующая в списке функция
FunctionATMAsText231
ATM_AsText
FunctionATMCreate415
ATM_Create
FunctionATMCreateRotate302
ATM_CreateRotate
FunctionATMCreateScale443
ATM_CreateScale
FunctionATMCreateTranslate428
ATM_CreateTranslate
FunctionATMCreateXRoll592
ATM_CreateXRoll
FunctionATMCreateYRoll543
ATM_CreateYRoll
FunctionATMCreateZRoll389
ATM_CreateZRoll
FunctionATMDeterminant251
ATM_Determinant
FunctionATMInvert406
ATM_Invert
FunctionATMIsInvertible261
ATM_IsInvertible
FunctionATMIsValid475
ATM_IsValid
FunctionATMMultiply212
ATM_Multiply
FunctionATMRotate567
ATM_Rotate
FunctionATMScale407
ATM_Scale
FunctionATMTransform668
ATM_Transform
FunctionATMTranslate165
ATM_Translate
FunctionATMXRoll646
ATM_XRoll
FunctionATMYRoll420
ATM_YRoll
FunctionATMZRoll533
ATM_ZRoll
FunctionAbs1
Abs
FunctionAcos171
Acos
FunctionAddPoint322
AddPoint
FunctionArea17
Area
FunctionAsBinary289
AsBinary
FunctionAsEWKB673
AsEWKB
FunctionAsEWKT244
AsEWKT
FunctionAsFGF374
AsFGF
FunctionAsGPB597
AsGPB
FunctionAsGeoJSON613
AsGeoJSON
FunctionAsGml526
AsGml
FunctionAsKml391
AsKml
FunctionAsSVG527
AsSVG
FunctionAsText411
AsText
FunctionAsWKT284
AsWKT
FunctionAsc77
Asc
FunctionAsin307
Asin
FunctionAtan300
Atan
FunctionAtan2589
Atan2
FunctionAvg44
Avg
FunctionAxiomaCentroid62
AxiomaCentroid
FunctionBdMPolyFromText480
BdMPolyFromText
FunctionBdMPolyFromWKB160
BdMPolyFromWKB
FunctionBdPolyFromText318
BdPolyFromText
FunctionBdPolyFromWKB641
BdPolyFromWKB
FunctionBoundary517
Boundary
FunctionBuffer230
Buffer
FunctionBuildArea607
BuildArea
FunctionBuildCircleMbr360
BuildCircleMbr
FunctionBuildMbr262
BuildMbr
FunctionCartesianArea19
CartesianArea
FunctionCartesianObjectDistance28
CartesianObjectDistance
FunctionCartesianObjectLen25
CartesianObjectLen
FunctionCartesianPerimeter22
CartesianPerimeter
FunctionCastAutomagic255
CastAutomagic
FunctionCastToBlob604
CastToBlob
FunctionCastToDouble611
CastToDouble
FunctionCastToGeometryCollection173
CastToGeometryCollection
FunctionCastToInteger380
CastToInteger
FunctionCastToLinestring445
CastToLinestring
FunctionCastToMulti409
CastToMulti
FunctionCastToMultiLinestring504
CastToMultiLinestring
FunctionCastToMultiPoint433
CastToMultiPoint
FunctionCastToMultiPolygon225
CastToMultiPolygon
FunctionCastToPoint150
CastToPoint
FunctionCastToPolygon623
CastToPolygon
FunctionCastToSingle489
CastToSingle
FunctionCastToText434
CastToText
FunctionCastToXY240
CastToXY
FunctionCastToXYM379
CastToXYM
FunctionCastToXYZ288
CastToXYZ
FunctionCastToXYZM172
CastToXYZM
FunctionCeil601
Ceil
FunctionCeiling273
Ceiling
FunctionCentroid495
Centroid
FunctionCentroidX26
CentroidX
FunctionCentroidY27
CentroidY
FunctionChar114
Char
FunctionChr677
Chr
FunctionChrDollar30
Chr$
FunctionCircularity306
Circularity
FunctionClosestPoint363
ClosestPoint
FunctionCoalesce117
Coalesce
FunctionCollect619
Collect
FunctionCollectionExtract369
CollectionExtract
FunctionCompressGeometry505
CompressGeometry
FunctionConcat78
concat
FunctionConcaveHull515
ConcaveHull
FunctionContains53
ContainsCentroid
FunctionContainsEntirely56
ST_Contains
FunctionConvexHull147
ConvexHull
FunctionCoordDimension603
CoordDimension
FunctionCoordSys66
CoordSys
FunctionCos49
Cos
FunctionCot626
Cot
FunctionCount47
Count
FunctionCoveredBy317
CoveredBy
FunctionCovers639
Covers
FunctionCreateUUID313
CreateUUID
FunctionCrosses642
Crosses
FunctionCumeDist121
Cume_Dist
FunctionCurDate9
CurDate
FunctionCurDateTime10
CurDateTime
FunctionCurTime11
CurTime
FunctionCurrentDate124
Current_Date
FunctionCurrentTime125
Current_Time
FunctionCurrentTimestamp91
Current_Timestamp
FunctionCurvosityIndex483
CurvosityIndex
FunctionCvtFromCh397
CvtFromCh
FunctionCvtFromCm201
CvtFromCm
FunctionCvtFromDm154
CvtFromDm
FunctionCvtFromFath518
CvtFromFath
FunctionCvtFromFt308
CvtFromFt
FunctionCvtFromIn388
CvtFromIn
FunctionCvtFromIndCh538
CvtFromIndCh
FunctionCvtFromIndFt627
CvtFromIndFt
FunctionCvtFromIndYd286
CvtFromIndYd
FunctionCvtFromKm653
CvtFromKm
FunctionCvtFromKmi181
CvtFromKmi
FunctionCvtFromLink162
CvtFromLink
FunctionCvtFromMi539
CvtFromMi
FunctionCvtFromMm440
CvtFromMm
FunctionCvtFromUsCh301
CvtFromUsCh
FunctionCvtFromUsFt418
CvtFromUsFt
FunctionCvtFromUsIn566
CvtFromUsIn
FunctionCvtFromUsMi344
CvtFromUsMi
FunctionCvtFromUsYd590
CvtFromUsYd
FunctionCvtFromYd193
CvtFromYd
FunctionCvtToCh274
CvtToCh
FunctionCvtToCm551
CvtToCm
FunctionCvtToDm210
CvtToDm
FunctionCvtToFath427
CvtToFath
FunctionCvtToFt281
CvtToFt
FunctionCvtToIn540
CvtToIn
FunctionCvtToIndCh617
CvtToIndCh
FunctionCvtToIndFt139
CvtToIndFt
FunctionCvtToIndYd498
CvtToIndYd
FunctionCvtToKm499
CvtToKm
FunctionCvtToKmi209
CvtToKmi
FunctionCvtToLink400
CvtToLink
FunctionCvtToMi591
CvtToMi
FunctionCvtToMm293
CvtToMm
FunctionCvtToUsCh419
CvtToUsCh
FunctionCvtToUsFt155
CvtToUsFt
FunctionCvtToUsIn559
CvtToUsIn
FunctionCvtToUsMi580
CvtToUsMi
FunctionCvtToUsYd414
CvtToUsYd
FunctionCvtToYd602
CvtToYd
FunctionDate115
Date
FunctionDateTime120
DateTime
FunctionDay5
Day
FunctionDecodeURL372
DecodeURL
FunctionDeformatNumber687
DeformatNumber
FunctionDeformatNumberDollar81
DeformatNumber$
FunctionDegrees237
Degrees
FunctionDelaunayTriangulation508
DelaunayTriangulation
FunctionDenseRank122
Dense_Rank
FunctionDifference546
Difference
FunctionDimension622
Dimension
FunctionDirNameFromPath205
DirNameFromPath
FunctionDisjoint529
Disjoint
FunctionDissolvePoints628
DissolvePoints
FunctionDissolveSegments238
DissolveSegments
FunctionDistance439
Distance
FunctionDivide696
divide
FunctionDownhillHeight453
DownhillHeight
FunctionEncodeURL216
EncodeURL
FunctionEndPoint215
EndPoint
FunctionEnsureClosedRings241
EnsureClosedRings
FunctionEntirelyWithin57
ST_Within
FunctionEnvelope583
Envelope
FunctionEquals272
Equals
FunctionExp667
Exp
FunctionExtent148
Extent
FunctionExteriorRing158
ExteriorRing
FunctionExtractMultiLinestring144
ExtractMultiLinestring
FunctionExtractMultiPoint555
ExtractMultiPoint
FunctionExtractMultiPolygon585
ExtractMultiPolygon
FunctionFileExtFromPath647
FileExtFromPath
FunctionFileNameFromPath159
FileNameFromPath
FunctionFirst0
FunctionFirstValue130
First_Value
FunctionFix73
Fix
FunctionFloor180
Floor
FunctionForceAsNull586
ForceAsNull
FunctionFormat685
Format
FunctionFormatDate686
FormatDate
FunctionFormatDateDollar80
FormatDate$
FunctionFormatDollar79
Format$
FunctionFormatNumber688
FormatNumber
FunctionFormatNumberDollar82
FormatNumber$
FunctionFormatTime694
FormatTime
FunctionFormatTimeDollar693
FormatTime$
FunctionFrechetDistance375
FrechetDistance
FunctionFromAxiGeo65
FromAxiGeo
FunctionFullFileNameFromPath258
FullFileNameFromPath
FunctionGARSMbr582
GARSMbr
FunctionGLength285
GLength
FunctionGUnion549
GUnion
FunctionGeodesicArcArea645
GeodesicArcArea
FunctionGeodesicArcHeight339
GeodesicArcHeight
FunctionGeodesicArcLength309
GeodesicArcLength
FunctionGeodesicCentralAngle358
GeodesicCentralAngle
FunctionGeodesicChordLength465
GeodesicChordLength
FunctionGeodesicLength140
GeodesicLength
FunctionGeomCollFromText316
GeomCollFromText
FunctionGeomCollFromWKB460
GeomCollFromWKB
FunctionGeomFromEWKB259
GeomFromEWKB
FunctionGeomFromEWKT353
GeomFromEWKT
FunctionGeomFromExifGpsBlob222
GeomFromExifGpsBlob
FunctionGeomFromFGF563
GeomFromFGF
FunctionGeomFromGML382
GeomFromGML
FunctionGeomFromGPB461
GeomFromGPB
FunctionGeomFromGeoJSON264
GeomFromGeoJSON
FunctionGeomFromKml577
GeomFromKml
FunctionGeomFromText228
GeomFromText
FunctionGeomFromWKB491
GeomFromWKB
FunctionGeometryCollectionFromText218
GeometryCollectionFromText
FunctionGeometryCollectionFromWKB557
GeometryCollectionFromWKB
FunctionGeometryFromText470
GeometryFromText
FunctionGeometryFromWKB525
GeometryFromWKB
FunctionGeometryN234
GeometryN
FunctionGeometryPointEncode535
GeometryPointEncode
FunctionGeometryType196
GeometryType
FunctionGeosVersion436
geos_version
FunctionGetDate13
GetDate
FunctionGetDecimalPrecision547
GetDecimalPrecision
FunctionGetGpkgMode134
GetGpkgMode
FunctionGetMimeType456
GetMimeType
FunctionGetTime12
GetTime
FunctionGlob59
glob
FunctionGpkgGetImageType187
gpkgGetImageType
FunctionGpkgMakePoint199
gpkgMakePoint
FunctionGpkgMakePointM133
gpkgMakePointM
FunctionGpkgMakePointZ437
gpkgMakePointZ
FunctionGpkgMakePointZM383
gpkgMakePointZM
FunctionGreatCircleLength367
GreatCircleLength
FunctionGroupConcat87
Group_Concat
FunctionHausdorffDistance662
HausdorffDistance
FunctionHex119
Hex
FunctionHexagonalGrid598
HexagonalGrid
FunctionHour14
Hour
FunctionIfNull123
IfNull
FunctionInStr31
InStr
FunctionInt51
Int
FunctionInteriorRingN283
InteriorRingN
FunctionIntersection365
Intersection
FunctionIntersects55
ST_Intersects
FunctionInvolution71
involution
FunctionIsClosed588
IsClosed
FunctionIsCompressedGeometryBlob266
IsCompressedGeometryBlob
FunctionIsDecimalNumber514
IsDecimalNumber
FunctionIsEmpty312
IsEmpty
FunctionIsExifBlob368
IsExifBlob
FunctionIsExifGpsBlob202
IsExifGpsBlob
FunctionIsGeometryBlob542
IsGeometryBlob
FunctionIsGifBlob211
IsGifBlob
FunctionIsInteger295
IsInteger
FunctionIsJP2Blob349
IsJP2Blob
FunctionIsJpegBlob223
IsJpegBlob
FunctionIsLowASCII541
IsLowASCII
FunctionIsNumber416
IsNumber
FunctionIsPauseEnabled141
IsPauseEnabled
FunctionIsPdfBlob256
IsPdfBlob
FunctionIsPngBlob571
IsPngBlob
FunctionIsRing246
IsRing
FunctionIsSimple625
IsSimple
FunctionIsTiffBlob532
IsTiffBlob
FunctionIsTinyPointBlob655
IsTinyPointBlob
FunctionIsValid245
IsValid
FunctionIsValidDetail161
IsValidDetail
FunctionIsValidGPB412
IsValidGPB
FunctionIsValidReason531
IsValidReason
FunctionIsWebpBlob654
IsWebpBlob
FunctionIsZipBlob195
IsZipBlob
FunctionJulianDay88
JulianDay
FunctionLCase678
LCase
FunctionLCaseDollar32
LCase$
FunctionLTrim129
LTrim
FunctionLTrimDollar34
LTrim$
FunctionLag126
Lag
FunctionLastValue95
Last_Value
FunctionLatitudeFromDMS509
LatitudeFromDMS
FunctionLead127
Lead
FunctionLeft681
Left
FunctionLeftDollar38
Left$
FunctionLen37
Len
FunctionLength131
Length
FunctionLike58
like
FunctionLikelihood94
Likelihood
FunctionLikely132
Likely
FunctionLineFromText207
LineFromText
FunctionLineFromWKB575
LineFromWKB
FunctionLineInterpolateEquidistantPoints528
Line_Interpolate_Equidistant_Points
FunctionLineInterpolatePoint537
Line_Interpolate_Point
FunctionLineLocatePoint386
Line_Locate_Point
FunctionLineMerge385
LineMerge
FunctionLineStringFromText507
LineStringFromText
FunctionLineStringFromWKB637
LineStringFromWKB
FunctionLineSubstring494
Line_Substring
FunctionLinesCutAtNodes462
LinesCutAtNodes
FunctionLinesFromRings182
LinesFromRings
FunctionLinestringAvgSegmentLength643
LinestringAvgSegmentLength
FunctionLinestringMaxSegmentLength291
LinestringMaxSegmentLength
FunctionLinestringMinSegmentLength496
LinestringMinSegmentLength
FunctionLn292
Ln
FunctionLog179
Log
FunctionLog10357
Log10
FunctionLog2299
Log2
FunctionLongLatToDMS387
LongLatToDMS
FunctionLongitudeFromDMS426
LongitudeFromDMS
FunctionLower128
Lower
FunctionM671
M
FunctionMD5Checksum610
MD5Checksum
FunctionMD5TotalChecksum446
MD5TotalChecksum
FunctionMLineFromText198
MLineFromText
FunctionMLineFromWKB448
MLineFromWKB
FunctionMPointFromText576
MPointFromText
FunctionMPointFromWKB243
MPointFromWKB
FunctionMPolyFromText297
MPolyFromText
FunctionMPolyFromWKB659
MPolyFromWKB
FunctionMakeArc510
MakeArc
FunctionMakeCircle485
MakeCircle
FunctionMakeCircularSector359
MakeCircularSector
FunctionMakeCircularStripe232
MakeCircularStripe
FunctionMakeEllipse398
MakeEllipse
FunctionMakeEllipticArc233
MakeEllipticArc
FunctionMakeEllipticSector519
MakeEllipticSector
FunctionMakeLine620
MakeLine
FunctionMakePoint390
MakePoint
FunctionMakePointM466
MakePointM
FunctionMakePointZ183
MakePointZ
FunctionMakePointZM166
MakePointZM
FunctionMakePolygon593
MakePolygon
FunctionMakeStringList221
MakeStringList
FunctionMakeValid697
MakeValid
FunctionMakeValidGeo698
MakeValidGeo
FunctionMax46
Max
FunctionMaximum2
Maximum
FunctionMbrContains487
MbrContains
FunctionMbrDisjoint468
MbrDisjoint
FunctionMbrEqual408
MbrEqual
FunctionMbrIntersects467
MbrIntersects
FunctionMbrMaxX561
MbrMaxX
FunctionMbrMaxY552
MbrMaxY
FunctionMbrMinX476
MbrMinX
FunctionMbrMinY135
MbrMinY
FunctionMbrOverlaps669
MbrOverlaps
FunctionMbrTouches378
MbrTouches
FunctionMbrWithin511
MbrWithin
FunctionMid683
Mid
FunctionMidDollar40
Mid$
FunctionMin45
Min
FunctionMinimum3
Minimum
FunctionMinute15
Minute
FunctionMonth6
Month
FunctionMultiLineStringFromText327
MultiLineStringFromText
FunctionMultiLineStringFromWKB649
MultiLineStringFromWKB
FunctionMultiPointFromText587
MultiPointFromText
FunctionMultiPointFromWKB478
MultiPointFromWKB
FunctionMultiPolygonFromText270
MultiPolygonFromText
FunctionMultiPolygonFromWKB315
MultiPolygonFromWKB
FunctionNTile89
NTile
FunctionNormalizeLonLat275
NormalizeLonLat
FunctionNthValue98
Nth_Value
FunctionNullIf90
NullIf
FunctionNumGeometries512
NumGeometries
FunctionNumInteriorRing254
NumInteriorRing
FunctionNumInteriorRings345
NumInteriorRings
FunctionNumPoints670
NumPoints
FunctionNumberToDate86
NumberToDate
FunctionObjectArea64
ObjectArea
FunctionObjectLen23
ObjectLen
FunctionObjectPerimeter63
ObjectPerimeter
FunctionOffsetCurve393
OffsetCurve
FunctionOverlaps394
Overlaps
FunctionPI606
PI
FunctionPROJAsProjString550
PROJ_AsProjString
FunctionPROJAsWKT298
PROJ_AsWKT
FunctionPROJGetDatabasePath248
PROJ_GetDatabasePath
FunctionPROJGuessSridFromWKT666
PROJ_GuessSridFromWKT
FunctionPause194
Pause
FunctionPercentRank111
Percent_Rank
FunctionPerimeter20
Perimeter
FunctionPointFromText362
PointFromText
FunctionPointFromWKB186
PointFromWKB
FunctionPointN333
PointN
FunctionPointOnSurface569
PointOnSurface
FunctionPolyFromText672
PolyFromText
FunctionPolyFromWKB381
PolyFromWKB
FunctionPolygonFromText217
PolygonFromText
FunctionPolygonFromWKB556
PolygonFromWKB
FunctionPolygonize484
Polygonize
FunctionPow170
Pow
FunctionPower631
Power
FunctionPresentFirst1
Abs
FunctionPrintF93
PrintF
FunctionProj4Version675
proj4_version
FunctionProjVersion558
proj_version
FunctionProper680
Proper
FunctionProperDollar36
Proper$
FunctionPtDistWithin438
PtDistWithin
FunctionQuote92
Quote
FunctionQuotient70
quotient
FunctionRTrim97
RTrim
FunctionRTrimDollar35
RTrim$
FunctionRadians153
Radians
FunctionRandom99
Random
FunctionRandomBLOB109
RandomBLOB
FunctionRank96
Rank
FunctionReflectCoordinates553
ReflectCoordinates
FunctionReflectCoords562
ReflectCoords
FunctionRelate442
Relate
FunctionRemoveExtraSpaces226
RemoveExtraSpaces
FunctionRemovePoint500
RemovePoint
FunctionRemoveRepeatedPoints417
RemoveRepeatedPoints
FunctionReplace105
Replace
FunctionResemblance69
Resemblance
FunctionRight682
Right
FunctionRightDollar39
Right$
FunctionRingsCutAtNodes660
RingsCutAtNodes
FunctionRotateCoordinates294
RotateCoordinates
FunctionRotateCoords657
RotateCoords
FunctionRound4
Round
FunctionRoundBy692
RoundBy
FunctionRoundTo691
RoundTo
FunctionRowNum48
RowNum
FunctionRowNumber112
Row_Number
FunctionSRID184
SRID
FunctionSTAddMeasure203
ST_AddMeasure
FunctionSTAddPoint656
ST_AddPoint
FunctionSTArea236
ST_Area
FunctionSTAsBinary564
ST_AsBinary
FunctionSTAsText346
ST_AsText
FunctionSTBdMPolyFromText168
ST_BdMPolyFromText
FunctionSTBdMPolyFromWKB464
ST_BdMPolyFromWKB
FunctionSTBdPolyFromText651
ST_BdPolyFromText
FunctionSTBdPolyFromWKB145
ST_BdPolyFromWKB
FunctionSTBoundary454
ST_Boundary
FunctionSTBuffer565
ST_Buffer
FunctionSTBuildArea164
ST_BuildArea
FunctionSTCentroid191
ST_Centroid
FunctionSTClosestPoint661
ST_ClosestPoint
FunctionSTCollect267
ST_Collect
FunctionSTCollectionExtract474
ST_CollectionExtract
FunctionSTConcaveHull290
ST_ConcaveHull
FunctionSTConvexHull579
ST_ConvexHull
FunctionSTCoveredBy605
ST_CoveredBy
FunctionSTCovers328
ST_Covers
FunctionSTCrosses146
ST_Crosses
FunctionSTCurvosityIndex616
ST_CurvosityIndex
FunctionSTDelaunayTriangulation451
ST_DelaunayTriangulation
FunctionSTDifference208
ST_Difference
FunctionSTDimension269
ST_Dimension
FunctionSTDisjoint229
ST_Disjoint
FunctionSTDissolvePoints250
ST_DissolvePoints
FunctionSTDissolveSegments142
ST_DissolveSegments
FunctionSTDistance260
ST_Distance
FunctionSTDownhillHeight482
ST_DownhillHeight
FunctionSTDrapeLine450
ST_DrapeLine
FunctionSTDrapeLineExceptions265
ST_DrapeLineExceptions
FunctionSTEndPoint370
ST_EndPoint
FunctionSTEnvIntersects323
ST_EnvIntersects
FunctionSTEnvelope522
ST_Envelope
FunctionSTEnvelopesIntersects311
ST_EnvelopesIntersects
FunctionSTEquals219
ST_Equals
FunctionSTExpand595
ST_Expand
FunctionSTExteriorRing149
ST_ExteriorRing
FunctionSTForceLHR276
ST_ForceLHR
FunctionSTForcePolygonCCW459
ST_ForcePolygonCCW
FunctionSTForcePolygonCW371
ST_ForcePolygonCW
FunctionSTFrechetDistance640
ST_FrechetDistance
FunctionSTGeneralize376
ST_Generalize
FunctionSTGeomCollFromText206
ST_GeomCollFromText
FunctionSTGeomCollFromWKB574
ST_GeomCollFromWKB
FunctionSTGeomFromText636
ST_GeomFromText
FunctionSTGeomFromWKB174
ST_GeomFromWKB
FunctionSTGeometryCollectionFromText373
ST_GeometryCollectionFromText
FunctionSTGeometryCollectionFromWKB630
ST_GeometryCollectionFromWKB
FunctionSTGeometryFromText277
ST_GeometryFromText
FunctionSTGeometryFromWKB296
ST_GeometryFromWKB
FunctionSTGeometryN554
ST_GeometryN
FunctionSTGeometryType536
ST_GeometryType
FunctionSTHausdorffDistance424
ST_HausdorffDistance
FunctionSTHexagonalGrid355
ST_HexagonalGrid
FunctionSTInteriorRingN568
ST_InteriorRingN
FunctionSTInterpolatePoint350
ST_InterpolatePoint
FunctionSTIntersection663
ST_Intersection
FunctionSTIs3D609
ST_Is3D
FunctionSTIsClosed377
ST_IsClosed
FunctionSTIsEmpty224
ST_IsEmpty
FunctionSTIsMeasured335
ST_IsMeasured
FunctionSTIsPolygonCCW635
ST_IsPolygonCCW
FunctionSTIsPolygonCW523
ST_IsPolygonCW
FunctionSTIsRing644
ST_IsRing
FunctionSTIsSimple247
ST_IsSimple
FunctionSTIsValid151
ST_IsValid
FunctionSTIsValidDetail138
ST_IsValidDetail
FunctionSTIsValidReason280
ST_IsValidReason
FunctionSTIsValidTrajectory405
ST_IsValidTrajectory
FunctionSTLength330
ST_Length
FunctionSTLineFromText544
ST_LineFromText
FunctionSTLineFromWKB624
ST_LineFromWKB
FunctionSTLineInterpolateEquidistantPoints278
ST_Line_Interpolate_Equidistant_Points
FunctionSTLineInterpolatePoint441
ST_Line_Interpolate_Point
FunctionSTLineLocatePoint190
ST_Line_Locate_Point
FunctionSTLineMerge188
ST_LineMerge
FunctionSTLineStringFromText197
ST_LineStringFromText
FunctionSTLineStringFromWKB447
ST_LineStringFromWKB
FunctionSTLineSubstring189
ST_Line_Substring
FunctionSTLinesCutAtNodes304
ST_LinesCutAtNodes
FunctionSTLinesFromRings501
ST_LinesFromRings
FunctionSTLinestringAvgSegmentLength329
ST_LinestringAvgSegmentLength
FunctionSTLinestringMaxSegmentLength570
ST_LinestringMaxSegmentLength
FunctionSTLinestringMinSegmentLength192
ST_LinestringMinSegmentLength
FunctionSTLocateAlong163
ST_LocateAlong
FunctionSTLocateAlongMeasure560
ST_Locate_Along_Measure
FunctionSTLocateBetween331
ST_LocateBetween
FunctionSTLocateBetweenMeasures310
ST_Locate_Between_Measures
FunctionSTM432
ST_M
FunctionSTMLineFromText303
ST_MLineFromText
FunctionSTMLineFromWKB361
ST_MLineFromWKB
FunctionSTMPointFromText175
ST_MPointFromText
FunctionSTMPointFromWKB469
ST_MPointFromWKB
FunctionSTMPolyFromText490
ST_MPolyFromText
FunctionSTMPolyFromWKB167
ST_MPolyFromWKB
FunctionSTMakePolygon252
ST_MakePolygon
FunctionSTMaxM287
ST_MaxM
FunctionSTMaxX521
ST_MaxX
FunctionSTMaxY257
ST_MaxY
FunctionSTMaxZ594
ST_MaxZ
FunctionSTMinM351
ST_MinM
FunctionSTMinX340
ST_MinX
FunctionSTMinY431
ST_MinY
FunctionSTMinZ513
ST_MinZ
FunctionSTMulti263
ST_Multi
FunctionSTMultiLineStringFromText612
ST_MultiLineStringFromText
FunctionSTMultiLineStringFromWKB336
ST_MultiLineStringFromWKB
FunctionSTMultiPointFromText524
ST_MultiPointFromText
FunctionSTMultiPointFromWKB325
ST_MultiPointFromWKB
FunctionSTMultiPolygonFromText341
ST_MultiPolygonFromText
FunctionSTMultiPolygonFromWKB227
ST_MultiPolygonFromWKB
FunctionSTNDims204
ST_NDims
FunctionSTNPoints214
ST_NPoints
FunctionSTNRings634
ST_NRings
FunctionSTNumGeometries457
ST_NumGeometries
FunctionSTNumInteriorRing157
ST_NumInteriorRing
FunctionSTNumPoints430
ST_NumPoints
FunctionSTOffsetCurve338
ST_OffsetCurve
FunctionSTOverlaps178
ST_Overlaps
FunctionSTPerimeter320
ST_Perimeter
FunctionSTPoint486
ST_Point
FunctionSTPointFromText410
ST_PointFromText
FunctionSTPointFromWKB506
ST_PointFromWKB
FunctionSTPointN136
ST_PointN
FunctionSTPointOnSurface169
ST_PointOnSurface
FunctionSTPolyFromText326
ST_PolyFromText
FunctionSTPolyFromWKB648
ST_PolyFromWKB
FunctionSTPolygonFromText352
ST_PolygonFromText
FunctionSTPolygonFromWKB596
ST_PolygonFromWKB
FunctionSTPolygonize618
ST_Polygonize
FunctionSTRelate356
ST_Relate
FunctionSTRelateMatch481
ST_RelateMatch
FunctionSTRemovePoint401
ST_RemovePoint
FunctionSTReverse185
ST_Reverse
FunctionSTRingsCutAtNodes423
ST_RingsCutAtNodes
FunctionSTSRID503
ST_SRID
FunctionSTSetEndPoint421
ST_SetEndPoint
FunctionSTSetPoint253
ST_SetPoint
FunctionSTSetStartPoint282
ST_SetStartPoint
FunctionSTSharedPaths472
ST_SharedPaths
FunctionSTShiftLongitude402
ST_Shift_Longitude
FunctionSTShortestLine452
ST_ShortestLine
FunctionSTSimplify319
ST_Simplify
FunctionSTSimplifyPreserveTopology395
ST_SimplifyPreserveTopology
FunctionSTSingleSidedBuffer305
ST_SingleSidedBuffer
FunctionSTSnap493
ST_Snap
FunctionSTSnapToGrid213
ST_SnapToGrid
FunctionSTSquareGrid599
ST_SquareGrid
FunctionSTStartPoint137
ST_StartPoint
FunctionSTSymDifference279
ST_SymDifference
FunctionSTTouches200
ST_Touches
FunctionSTTrajectoryInterpolatePoint581
ST_TrajectoryInterpolatePoint
FunctionSTTransform152
ST_Transform
FunctionSTTransformXY321
ST_TransformXY
FunctionSTTransformXYZ600
ST_TransformXYZ
FunctionSTTranslate520
ST_Translate
FunctionSTTriangularGrid413
ST_TriangularGrid
FunctionSTUnaryUnion399
ST_UnaryUnion
FunctionSTUnion235
ST_Union
FunctionSTUpDownHeight396
ST_UpDownHeight
FunctionSTUphillHeight665
ST_UphillHeight
FunctionSTVoronojDiagram492
ST_VoronojDiagram
FunctionSTWKBToSQL477
ST_WKBToSQL
FunctionSTWKTToSQL242
ST_WKTToSQL
FunctionSTX403
ST_X
FunctionSTY239
ST_Y
FunctionSTZ573
ST_Z
FunctionSanitizeGeometry324
SanitizeGeometry
FunctionScaleCoordinates429
ScaleCoordinates
FunctionScaleCoords156
ScaleCoords
FunctionSecond16
Second
FunctionSetEndPoint444
SetEndPoint
FunctionSetPoint629
SetPoint
FunctionSetSRID584
SetSRID
FunctionSetStartPoint534
SetStartPoint
FunctionSgn72
Sgn
FunctionSharedPaths364
SharedPaths
FunctionShiftCoordinates608
ShiftCoordinates
FunctionShiftCoords332
ShiftCoords
FunctionShortestLine516
ShortestLine
FunctionSign220
Sign
FunctionSimplify664
Simplify
FunctionSimplifyPreserveTopology614
SimplifyPreserveTopology
FunctionSin50
Sin
FunctionSingleSidedBuffer463
SingleSidedBuffer
FunctionSnap177
Snap
FunctionSnapToGrid548
SnapToGrid
FunctionSpace689
Space
FunctionSpaceDollar83
Space$
FunctionSpatialiteTargetCPU479
spatialite_target_cpu
FunctionSpatialiteVersion471
spatialite_version
FunctionSphericalArea18
SphericalArea
FunctionSphericalObjectDistance29
SphericalObjectDistance
FunctionSphericalObjectLen24
SphericalObjectLen
FunctionSphericalPerimeter21
SphericalPerimeter
FunctionSqliteSourceId674
sqlite_source_id
FunctionSqliteVersion116
Sqlite_Version
FunctionSqr676
Sqr
FunctionSqrt74
Sqrt
FunctionSquareGrid632
SquareGrid
FunctionSridFromAuthCRS488
SridFromAuthCRS
FunctionSridGetAxis1Name638
SridGetAxis_1_Name
FunctionSridGetAxis1Orientation342
SridGetAxis_1_Orientation
FunctionSridGetAxis2Name337
SridGetAxis_2_Name
FunctionSridGetAxis2Orientation435
SridGetAxis_2_Orientation
FunctionSridGetDatum449
SridGetDatum
FunctionSridGetEllipsoid545
SridGetEllipsoid
FunctionSridGetPrimeMeridian392
SridGetPrimeMeridian
FunctionSridGetProjection347
SridGetProjection
FunctionSridGetSpheroid578
SridGetSpheroid
FunctionSridGetUnit650
SridGetUnit
FunctionSridHasFlippedAxes422
SridHasFlippedAxes
FunctionSridIsGeographic354
SridIsGeographic
FunctionSridIsProjected404
SridIsProjected
FunctionStartPoint334
StartPoint
FunctionStddevPop497
Stddev_pop
FunctionStddevSamp455
Stddev_samp
FunctionStr684
Str
FunctionStrDollar42
Str$
FunctionStrFTime108
StrFTime
FunctionString690
String
FunctionStringCompare60
StringCompare
FunctionStringDollar84
String$
FunctionStringLocaleCompare61
StringCompareIntl
FunctionStringToDate85
StringToDate
FunctionSubstr103
Substr
FunctionSubstring104
Substring
FunctionSum43
Sum
FunctionSwapCoordinates621
SwapCoordinates
FunctionSwapCoords143
SwapCoords
FunctionSymDifference530
SymDifference
FunctionTableCoordSys699
TableCoordSys
FunctionTan425
Tan
FunctionTime101
Time
FunctionTinyPointEncode268
TinyPointEncode
FunctionToAxiGeo67
ToAxiGeo
FunctionToGARS572
ToGARS
FunctionToSLGeo695
ToSLGeo
FunctionTotal102
Total
FunctionTouches271
Touches
FunctionTransform249
Transform
FunctionTransformToAxiGeo68
TransformToAxiGeo
FunctionTransformToSLGeo700
TransformToSLGeo
FunctionTransformXY473
TransformXY
FunctionTransformXYZ633
TransformXYZ
FunctionTriangularGrid343
TriangularGrid
FunctionTrim100
Trim
FunctionTypeOf107
TypeOf
FunctionUCase679
UCase
FunctionUCaseDollar33
UCase$
FunctionUnaryUnion384
UnaryUnion
FunctionUncompressGeometry314
UncompressGeometry
FunctionUnicode110
Unicode
FunctionUnlikely113
Unlikely
FunctionUpDownHeight615
UpDownHeight
FunctionUphillHeight366
UphillHeight
FunctionUpper106
Upper
FunctionVal41
Val
FunctionVarPop348
Var_pop
FunctionVarSamp652
Var_samp
FunctionVoronojDiagram176
VoronojDiagram
FunctionWeekday8
Weekday
FunctionWithin54
CentroidWithin
FunctionWtAvg75
WtAvg
FunctionWtAvgSafe76
WtAvgSafe
FunctionX502
X
FunctionXor52
xor
FunctionY658
Y
FunctionYear7
Year
FunctionZ458
Z
FunctionZeroBlob118
ZeroBlob
FunctionNameCount701
Общее число функций
-
class
axioma.core.sql.FunctionSet¶ Интерфейс получения информации о функциях sql-диалекта
Методы:
axioma.core.sql.add(functionName)¶Добавление функции к набору
- Параметры
functionName (
FunctionName) – Идентификатор функции
axioma.core.sql.fillByMask(mask, value=true)¶Добавить к набору функции указанного типа или исключить их из набора.
- Параметры
mask (
bool) – Тип функцийmask – Признак добавления функций к набору (false - исключение функций из набора)
axioma.core.sql.functions(filter)¶Получить список функций с описаниями, соответствующих фильтру
- Параметры
filter (
FunctionFilter) – Фильтр, накладываемый на набор функций- Результат
Список названий и описаний функций
- Тип результата
axioma.core.sql.name(functionName)¶Получить название конкретно взятой функции
- Параметры
functionName (
FunctionName) – Идентификатор функции- Результат
Название функции
- Тип результата