FunctionSet - Набор функций sql-диалекта¶
-
class
axioma.core.sql.
FunctionName
¶ Идентификаторы функций
Возможные функции диалектов FunctionName
:¶Тип
Значение
Название функции
FunctionAbsent
0
Отсутствующая в списке функция
FunctionATMAsText
231
ATM_AsText
FunctionATMCreate
415
ATM_Create
FunctionATMCreateRotate
302
ATM_CreateRotate
FunctionATMCreateScale
443
ATM_CreateScale
FunctionATMCreateTranslate
428
ATM_CreateTranslate
FunctionATMCreateXRoll
592
ATM_CreateXRoll
FunctionATMCreateYRoll
543
ATM_CreateYRoll
FunctionATMCreateZRoll
389
ATM_CreateZRoll
FunctionATMDeterminant
251
ATM_Determinant
FunctionATMInvert
406
ATM_Invert
FunctionATMIsInvertible
261
ATM_IsInvertible
FunctionATMIsValid
475
ATM_IsValid
FunctionATMMultiply
212
ATM_Multiply
FunctionATMRotate
567
ATM_Rotate
FunctionATMScale
407
ATM_Scale
FunctionATMTransform
668
ATM_Transform
FunctionATMTranslate
165
ATM_Translate
FunctionATMXRoll
646
ATM_XRoll
FunctionATMYRoll
420
ATM_YRoll
FunctionATMZRoll
533
ATM_ZRoll
FunctionAbs
1
Abs
FunctionAcos
171
Acos
FunctionAddPoint
322
AddPoint
FunctionArea
17
Area
FunctionAsBinary
289
AsBinary
FunctionAsEWKB
673
AsEWKB
FunctionAsEWKT
244
AsEWKT
FunctionAsFGF
374
AsFGF
FunctionAsGPB
597
AsGPB
FunctionAsGeoJSON
613
AsGeoJSON
FunctionAsGml
526
AsGml
FunctionAsKml
391
AsKml
FunctionAsSVG
527
AsSVG
FunctionAsText
411
AsText
FunctionAsWKT
284
AsWKT
FunctionAsc
77
Asc
FunctionAsin
307
Asin
FunctionAtan
300
Atan
FunctionAtan2
589
Atan2
FunctionAvg
44
Avg
FunctionAxiomaCentroid
62
AxiomaCentroid
FunctionBdMPolyFromText
480
BdMPolyFromText
FunctionBdMPolyFromWKB
160
BdMPolyFromWKB
FunctionBdPolyFromText
318
BdPolyFromText
FunctionBdPolyFromWKB
641
BdPolyFromWKB
FunctionBoundary
517
Boundary
FunctionBuffer
230
Buffer
FunctionBuildArea
607
BuildArea
FunctionBuildCircleMbr
360
BuildCircleMbr
FunctionBuildMbr
262
BuildMbr
FunctionCartesianArea
19
CartesianArea
FunctionCartesianObjectDistance
28
CartesianObjectDistance
FunctionCartesianObjectLen
25
CartesianObjectLen
FunctionCartesianPerimeter
22
CartesianPerimeter
FunctionCastAutomagic
255
CastAutomagic
FunctionCastToBlob
604
CastToBlob
FunctionCastToDouble
611
CastToDouble
FunctionCastToGeometryCollection
173
CastToGeometryCollection
FunctionCastToInteger
380
CastToInteger
FunctionCastToLinestring
445
CastToLinestring
FunctionCastToMulti
409
CastToMulti
FunctionCastToMultiLinestring
504
CastToMultiLinestring
FunctionCastToMultiPoint
433
CastToMultiPoint
FunctionCastToMultiPolygon
225
CastToMultiPolygon
FunctionCastToPoint
150
CastToPoint
FunctionCastToPolygon
623
CastToPolygon
FunctionCastToSingle
489
CastToSingle
FunctionCastToText
434
CastToText
FunctionCastToXY
240
CastToXY
FunctionCastToXYM
379
CastToXYM
FunctionCastToXYZ
288
CastToXYZ
FunctionCastToXYZM
172
CastToXYZM
FunctionCeil
601
Ceil
FunctionCeiling
273
Ceiling
FunctionCentroid
495
Centroid
FunctionCentroidX
26
CentroidX
FunctionCentroidY
27
CentroidY
FunctionChar
114
Char
FunctionChr
677
Chr
FunctionChrDollar
30
Chr$
FunctionCircularity
306
Circularity
FunctionClosestPoint
363
ClosestPoint
FunctionCoalesce
117
Coalesce
FunctionCollect
619
Collect
FunctionCollectionExtract
369
CollectionExtract
FunctionCompressGeometry
505
CompressGeometry
FunctionConcat
78
concat
FunctionConcaveHull
515
ConcaveHull
FunctionContains
53
ContainsCentroid
FunctionContainsEntirely
56
ST_Contains
FunctionConvexHull
147
ConvexHull
FunctionCoordDimension
603
CoordDimension
FunctionCoordSys
66
CoordSys
FunctionCos
49
Cos
FunctionCot
626
Cot
FunctionCount
47
Count
FunctionCoveredBy
317
CoveredBy
FunctionCovers
639
Covers
FunctionCreateUUID
313
CreateUUID
FunctionCrosses
642
Crosses
FunctionCumeDist
121
Cume_Dist
FunctionCurDate
9
CurDate
FunctionCurDateTime
10
CurDateTime
FunctionCurTime
11
CurTime
FunctionCurrentDate
124
Current_Date
FunctionCurrentTime
125
Current_Time
FunctionCurrentTimestamp
91
Current_Timestamp
FunctionCurvosityIndex
483
CurvosityIndex
FunctionCvtFromCh
397
CvtFromCh
FunctionCvtFromCm
201
CvtFromCm
FunctionCvtFromDm
154
CvtFromDm
FunctionCvtFromFath
518
CvtFromFath
FunctionCvtFromFt
308
CvtFromFt
FunctionCvtFromIn
388
CvtFromIn
FunctionCvtFromIndCh
538
CvtFromIndCh
FunctionCvtFromIndFt
627
CvtFromIndFt
FunctionCvtFromIndYd
286
CvtFromIndYd
FunctionCvtFromKm
653
CvtFromKm
FunctionCvtFromKmi
181
CvtFromKmi
FunctionCvtFromLink
162
CvtFromLink
FunctionCvtFromMi
539
CvtFromMi
FunctionCvtFromMm
440
CvtFromMm
FunctionCvtFromUsCh
301
CvtFromUsCh
FunctionCvtFromUsFt
418
CvtFromUsFt
FunctionCvtFromUsIn
566
CvtFromUsIn
FunctionCvtFromUsMi
344
CvtFromUsMi
FunctionCvtFromUsYd
590
CvtFromUsYd
FunctionCvtFromYd
193
CvtFromYd
FunctionCvtToCh
274
CvtToCh
FunctionCvtToCm
551
CvtToCm
FunctionCvtToDm
210
CvtToDm
FunctionCvtToFath
427
CvtToFath
FunctionCvtToFt
281
CvtToFt
FunctionCvtToIn
540
CvtToIn
FunctionCvtToIndCh
617
CvtToIndCh
FunctionCvtToIndFt
139
CvtToIndFt
FunctionCvtToIndYd
498
CvtToIndYd
FunctionCvtToKm
499
CvtToKm
FunctionCvtToKmi
209
CvtToKmi
FunctionCvtToLink
400
CvtToLink
FunctionCvtToMi
591
CvtToMi
FunctionCvtToMm
293
CvtToMm
FunctionCvtToUsCh
419
CvtToUsCh
FunctionCvtToUsFt
155
CvtToUsFt
FunctionCvtToUsIn
559
CvtToUsIn
FunctionCvtToUsMi
580
CvtToUsMi
FunctionCvtToUsYd
414
CvtToUsYd
FunctionCvtToYd
602
CvtToYd
FunctionDate
115
Date
FunctionDateTime
120
DateTime
FunctionDay
5
Day
FunctionDecodeURL
372
DecodeURL
FunctionDeformatNumber
687
DeformatNumber
FunctionDeformatNumberDollar
81
DeformatNumber$
FunctionDegrees
237
Degrees
FunctionDelaunayTriangulation
508
DelaunayTriangulation
FunctionDenseRank
122
Dense_Rank
FunctionDifference
546
Difference
FunctionDimension
622
Dimension
FunctionDirNameFromPath
205
DirNameFromPath
FunctionDisjoint
529
Disjoint
FunctionDissolvePoints
628
DissolvePoints
FunctionDissolveSegments
238
DissolveSegments
FunctionDistance
439
Distance
FunctionDivide
696
divide
FunctionDownhillHeight
453
DownhillHeight
FunctionEncodeURL
216
EncodeURL
FunctionEndPoint
215
EndPoint
FunctionEnsureClosedRings
241
EnsureClosedRings
FunctionEntirelyWithin
57
ST_Within
FunctionEnvelope
583
Envelope
FunctionEquals
272
Equals
FunctionExp
667
Exp
FunctionExtent
148
Extent
FunctionExteriorRing
158
ExteriorRing
FunctionExtractMultiLinestring
144
ExtractMultiLinestring
FunctionExtractMultiPoint
555
ExtractMultiPoint
FunctionExtractMultiPolygon
585
ExtractMultiPolygon
FunctionFileExtFromPath
647
FileExtFromPath
FunctionFileNameFromPath
159
FileNameFromPath
FunctionFirst
0
FunctionFirstValue
130
First_Value
FunctionFix
73
Fix
FunctionFloor
180
Floor
FunctionForceAsNull
586
ForceAsNull
FunctionFormat
685
Format
FunctionFormatDate
686
FormatDate
FunctionFormatDateDollar
80
FormatDate$
FunctionFormatDollar
79
Format$
FunctionFormatNumber
688
FormatNumber
FunctionFormatNumberDollar
82
FormatNumber$
FunctionFormatTime
694
FormatTime
FunctionFormatTimeDollar
693
FormatTime$
FunctionFrechetDistance
375
FrechetDistance
FunctionFromAxiGeo
65
FromAxiGeo
FunctionFullFileNameFromPath
258
FullFileNameFromPath
FunctionGARSMbr
582
GARSMbr
FunctionGLength
285
GLength
FunctionGUnion
549
GUnion
FunctionGeodesicArcArea
645
GeodesicArcArea
FunctionGeodesicArcHeight
339
GeodesicArcHeight
FunctionGeodesicArcLength
309
GeodesicArcLength
FunctionGeodesicCentralAngle
358
GeodesicCentralAngle
FunctionGeodesicChordLength
465
GeodesicChordLength
FunctionGeodesicLength
140
GeodesicLength
FunctionGeomCollFromText
316
GeomCollFromText
FunctionGeomCollFromWKB
460
GeomCollFromWKB
FunctionGeomFromEWKB
259
GeomFromEWKB
FunctionGeomFromEWKT
353
GeomFromEWKT
FunctionGeomFromExifGpsBlob
222
GeomFromExifGpsBlob
FunctionGeomFromFGF
563
GeomFromFGF
FunctionGeomFromGML
382
GeomFromGML
FunctionGeomFromGPB
461
GeomFromGPB
FunctionGeomFromGeoJSON
264
GeomFromGeoJSON
FunctionGeomFromKml
577
GeomFromKml
FunctionGeomFromText
228
GeomFromText
FunctionGeomFromWKB
491
GeomFromWKB
FunctionGeometryCollectionFromText
218
GeometryCollectionFromText
FunctionGeometryCollectionFromWKB
557
GeometryCollectionFromWKB
FunctionGeometryFromText
470
GeometryFromText
FunctionGeometryFromWKB
525
GeometryFromWKB
FunctionGeometryN
234
GeometryN
FunctionGeometryPointEncode
535
GeometryPointEncode
FunctionGeometryType
196
GeometryType
FunctionGeosVersion
436
geos_version
FunctionGetDate
13
GetDate
FunctionGetDecimalPrecision
547
GetDecimalPrecision
FunctionGetGpkgMode
134
GetGpkgMode
FunctionGetMimeType
456
GetMimeType
FunctionGetTime
12
GetTime
FunctionGlob
59
glob
FunctionGpkgGetImageType
187
gpkgGetImageType
FunctionGpkgMakePoint
199
gpkgMakePoint
FunctionGpkgMakePointM
133
gpkgMakePointM
FunctionGpkgMakePointZ
437
gpkgMakePointZ
FunctionGpkgMakePointZM
383
gpkgMakePointZM
FunctionGreatCircleLength
367
GreatCircleLength
FunctionGroupConcat
87
Group_Concat
FunctionHausdorffDistance
662
HausdorffDistance
FunctionHex
119
Hex
FunctionHexagonalGrid
598
HexagonalGrid
FunctionHour
14
Hour
FunctionIfNull
123
IfNull
FunctionInStr
31
InStr
FunctionInt
51
Int
FunctionInteriorRingN
283
InteriorRingN
FunctionIntersection
365
Intersection
FunctionIntersects
55
ST_Intersects
FunctionInvolution
71
involution
FunctionIsClosed
588
IsClosed
FunctionIsCompressedGeometryBlob
266
IsCompressedGeometryBlob
FunctionIsDecimalNumber
514
IsDecimalNumber
FunctionIsEmpty
312
IsEmpty
FunctionIsExifBlob
368
IsExifBlob
FunctionIsExifGpsBlob
202
IsExifGpsBlob
FunctionIsGeometryBlob
542
IsGeometryBlob
FunctionIsGifBlob
211
IsGifBlob
FunctionIsInteger
295
IsInteger
FunctionIsJP2Blob
349
IsJP2Blob
FunctionIsJpegBlob
223
IsJpegBlob
FunctionIsLowASCII
541
IsLowASCII
FunctionIsNumber
416
IsNumber
FunctionIsPauseEnabled
141
IsPauseEnabled
FunctionIsPdfBlob
256
IsPdfBlob
FunctionIsPngBlob
571
IsPngBlob
FunctionIsRing
246
IsRing
FunctionIsSimple
625
IsSimple
FunctionIsTiffBlob
532
IsTiffBlob
FunctionIsTinyPointBlob
655
IsTinyPointBlob
FunctionIsValid
245
IsValid
FunctionIsValidDetail
161
IsValidDetail
FunctionIsValidGPB
412
IsValidGPB
FunctionIsValidReason
531
IsValidReason
FunctionIsWebpBlob
654
IsWebpBlob
FunctionIsZipBlob
195
IsZipBlob
FunctionJulianDay
88
JulianDay
FunctionLCase
678
LCase
FunctionLCaseDollar
32
LCase$
FunctionLTrim
129
LTrim
FunctionLTrimDollar
34
LTrim$
FunctionLag
126
Lag
FunctionLastValue
95
Last_Value
FunctionLatitudeFromDMS
509
LatitudeFromDMS
FunctionLead
127
Lead
FunctionLeft
681
Left
FunctionLeftDollar
38
Left$
FunctionLen
37
Len
FunctionLength
131
Length
FunctionLike
58
like
FunctionLikelihood
94
Likelihood
FunctionLikely
132
Likely
FunctionLineFromText
207
LineFromText
FunctionLineFromWKB
575
LineFromWKB
FunctionLineInterpolateEquidistantPoints
528
Line_Interpolate_Equidistant_Points
FunctionLineInterpolatePoint
537
Line_Interpolate_Point
FunctionLineLocatePoint
386
Line_Locate_Point
FunctionLineMerge
385
LineMerge
FunctionLineStringFromText
507
LineStringFromText
FunctionLineStringFromWKB
637
LineStringFromWKB
FunctionLineSubstring
494
Line_Substring
FunctionLinesCutAtNodes
462
LinesCutAtNodes
FunctionLinesFromRings
182
LinesFromRings
FunctionLinestringAvgSegmentLength
643
LinestringAvgSegmentLength
FunctionLinestringMaxSegmentLength
291
LinestringMaxSegmentLength
FunctionLinestringMinSegmentLength
496
LinestringMinSegmentLength
FunctionLn
292
Ln
FunctionLog
179
Log
FunctionLog10
357
Log10
FunctionLog2
299
Log2
FunctionLongLatToDMS
387
LongLatToDMS
FunctionLongitudeFromDMS
426
LongitudeFromDMS
FunctionLower
128
Lower
FunctionM
671
M
FunctionMD5Checksum
610
MD5Checksum
FunctionMD5TotalChecksum
446
MD5TotalChecksum
FunctionMLineFromText
198
MLineFromText
FunctionMLineFromWKB
448
MLineFromWKB
FunctionMPointFromText
576
MPointFromText
FunctionMPointFromWKB
243
MPointFromWKB
FunctionMPolyFromText
297
MPolyFromText
FunctionMPolyFromWKB
659
MPolyFromWKB
FunctionMakeArc
510
MakeArc
FunctionMakeCircle
485
MakeCircle
FunctionMakeCircularSector
359
MakeCircularSector
FunctionMakeCircularStripe
232
MakeCircularStripe
FunctionMakeEllipse
398
MakeEllipse
FunctionMakeEllipticArc
233
MakeEllipticArc
FunctionMakeEllipticSector
519
MakeEllipticSector
FunctionMakeLine
620
MakeLine
FunctionMakePoint
390
MakePoint
FunctionMakePointM
466
MakePointM
FunctionMakePointZ
183
MakePointZ
FunctionMakePointZM
166
MakePointZM
FunctionMakePolygon
593
MakePolygon
FunctionMakeStringList
221
MakeStringList
FunctionMakeValid
697
MakeValid
FunctionMakeValidGeo
698
MakeValidGeo
FunctionMax
46
Max
FunctionMaximum
2
Maximum
FunctionMbrContains
487
MbrContains
FunctionMbrDisjoint
468
MbrDisjoint
FunctionMbrEqual
408
MbrEqual
FunctionMbrIntersects
467
MbrIntersects
FunctionMbrMaxX
561
MbrMaxX
FunctionMbrMaxY
552
MbrMaxY
FunctionMbrMinX
476
MbrMinX
FunctionMbrMinY
135
MbrMinY
FunctionMbrOverlaps
669
MbrOverlaps
FunctionMbrTouches
378
MbrTouches
FunctionMbrWithin
511
MbrWithin
FunctionMid
683
Mid
FunctionMidDollar
40
Mid$
FunctionMin
45
Min
FunctionMinimum
3
Minimum
FunctionMinute
15
Minute
FunctionMonth
6
Month
FunctionMultiLineStringFromText
327
MultiLineStringFromText
FunctionMultiLineStringFromWKB
649
MultiLineStringFromWKB
FunctionMultiPointFromText
587
MultiPointFromText
FunctionMultiPointFromWKB
478
MultiPointFromWKB
FunctionMultiPolygonFromText
270
MultiPolygonFromText
FunctionMultiPolygonFromWKB
315
MultiPolygonFromWKB
FunctionNTile
89
NTile
FunctionNormalizeLonLat
275
NormalizeLonLat
FunctionNthValue
98
Nth_Value
FunctionNullIf
90
NullIf
FunctionNumGeometries
512
NumGeometries
FunctionNumInteriorRing
254
NumInteriorRing
FunctionNumInteriorRings
345
NumInteriorRings
FunctionNumPoints
670
NumPoints
FunctionNumberToDate
86
NumberToDate
FunctionObjectArea
64
ObjectArea
FunctionObjectLen
23
ObjectLen
FunctionObjectPerimeter
63
ObjectPerimeter
FunctionOffsetCurve
393
OffsetCurve
FunctionOverlaps
394
Overlaps
FunctionPI
606
PI
FunctionPROJAsProjString
550
PROJ_AsProjString
FunctionPROJAsWKT
298
PROJ_AsWKT
FunctionPROJGetDatabasePath
248
PROJ_GetDatabasePath
FunctionPROJGuessSridFromWKT
666
PROJ_GuessSridFromWKT
FunctionPause
194
Pause
FunctionPercentRank
111
Percent_Rank
FunctionPerimeter
20
Perimeter
FunctionPointFromText
362
PointFromText
FunctionPointFromWKB
186
PointFromWKB
FunctionPointN
333
PointN
FunctionPointOnSurface
569
PointOnSurface
FunctionPolyFromText
672
PolyFromText
FunctionPolyFromWKB
381
PolyFromWKB
FunctionPolygonFromText
217
PolygonFromText
FunctionPolygonFromWKB
556
PolygonFromWKB
FunctionPolygonize
484
Polygonize
FunctionPow
170
Pow
FunctionPower
631
Power
FunctionPresentFirst
1
Abs
FunctionPrintF
93
PrintF
FunctionProj4Version
675
proj4_version
FunctionProjVersion
558
proj_version
FunctionProper
680
Proper
FunctionProperDollar
36
Proper$
FunctionPtDistWithin
438
PtDistWithin
FunctionQuote
92
Quote
FunctionQuotient
70
quotient
FunctionRTrim
97
RTrim
FunctionRTrimDollar
35
RTrim$
FunctionRadians
153
Radians
FunctionRandom
99
Random
FunctionRandomBLOB
109
RandomBLOB
FunctionRank
96
Rank
FunctionReflectCoordinates
553
ReflectCoordinates
FunctionReflectCoords
562
ReflectCoords
FunctionRelate
442
Relate
FunctionRemoveExtraSpaces
226
RemoveExtraSpaces
FunctionRemovePoint
500
RemovePoint
FunctionRemoveRepeatedPoints
417
RemoveRepeatedPoints
FunctionReplace
105
Replace
FunctionResemblance
69
Resemblance
FunctionRight
682
Right
FunctionRightDollar
39
Right$
FunctionRingsCutAtNodes
660
RingsCutAtNodes
FunctionRotateCoordinates
294
RotateCoordinates
FunctionRotateCoords
657
RotateCoords
FunctionRound
4
Round
FunctionRoundBy
692
RoundBy
FunctionRoundTo
691
RoundTo
FunctionRowNum
48
RowNum
FunctionRowNumber
112
Row_Number
FunctionSRID
184
SRID
FunctionSTAddMeasure
203
ST_AddMeasure
FunctionSTAddPoint
656
ST_AddPoint
FunctionSTArea
236
ST_Area
FunctionSTAsBinary
564
ST_AsBinary
FunctionSTAsText
346
ST_AsText
FunctionSTBdMPolyFromText
168
ST_BdMPolyFromText
FunctionSTBdMPolyFromWKB
464
ST_BdMPolyFromWKB
FunctionSTBdPolyFromText
651
ST_BdPolyFromText
FunctionSTBdPolyFromWKB
145
ST_BdPolyFromWKB
FunctionSTBoundary
454
ST_Boundary
FunctionSTBuffer
565
ST_Buffer
FunctionSTBuildArea
164
ST_BuildArea
FunctionSTCentroid
191
ST_Centroid
FunctionSTClosestPoint
661
ST_ClosestPoint
FunctionSTCollect
267
ST_Collect
FunctionSTCollectionExtract
474
ST_CollectionExtract
FunctionSTConcaveHull
290
ST_ConcaveHull
FunctionSTConvexHull
579
ST_ConvexHull
FunctionSTCoveredBy
605
ST_CoveredBy
FunctionSTCovers
328
ST_Covers
FunctionSTCrosses
146
ST_Crosses
FunctionSTCurvosityIndex
616
ST_CurvosityIndex
FunctionSTDelaunayTriangulation
451
ST_DelaunayTriangulation
FunctionSTDifference
208
ST_Difference
FunctionSTDimension
269
ST_Dimension
FunctionSTDisjoint
229
ST_Disjoint
FunctionSTDissolvePoints
250
ST_DissolvePoints
FunctionSTDissolveSegments
142
ST_DissolveSegments
FunctionSTDistance
260
ST_Distance
FunctionSTDownhillHeight
482
ST_DownhillHeight
FunctionSTDrapeLine
450
ST_DrapeLine
FunctionSTDrapeLineExceptions
265
ST_DrapeLineExceptions
FunctionSTEndPoint
370
ST_EndPoint
FunctionSTEnvIntersects
323
ST_EnvIntersects
FunctionSTEnvelope
522
ST_Envelope
FunctionSTEnvelopesIntersects
311
ST_EnvelopesIntersects
FunctionSTEquals
219
ST_Equals
FunctionSTExpand
595
ST_Expand
FunctionSTExteriorRing
149
ST_ExteriorRing
FunctionSTForceLHR
276
ST_ForceLHR
FunctionSTForcePolygonCCW
459
ST_ForcePolygonCCW
FunctionSTForcePolygonCW
371
ST_ForcePolygonCW
FunctionSTFrechetDistance
640
ST_FrechetDistance
FunctionSTGeneralize
376
ST_Generalize
FunctionSTGeomCollFromText
206
ST_GeomCollFromText
FunctionSTGeomCollFromWKB
574
ST_GeomCollFromWKB
FunctionSTGeomFromText
636
ST_GeomFromText
FunctionSTGeomFromWKB
174
ST_GeomFromWKB
FunctionSTGeometryCollectionFromText
373
ST_GeometryCollectionFromText
FunctionSTGeometryCollectionFromWKB
630
ST_GeometryCollectionFromWKB
FunctionSTGeometryFromText
277
ST_GeometryFromText
FunctionSTGeometryFromWKB
296
ST_GeometryFromWKB
FunctionSTGeometryN
554
ST_GeometryN
FunctionSTGeometryType
536
ST_GeometryType
FunctionSTHausdorffDistance
424
ST_HausdorffDistance
FunctionSTHexagonalGrid
355
ST_HexagonalGrid
FunctionSTInteriorRingN
568
ST_InteriorRingN
FunctionSTInterpolatePoint
350
ST_InterpolatePoint
FunctionSTIntersection
663
ST_Intersection
FunctionSTIs3D
609
ST_Is3D
FunctionSTIsClosed
377
ST_IsClosed
FunctionSTIsEmpty
224
ST_IsEmpty
FunctionSTIsMeasured
335
ST_IsMeasured
FunctionSTIsPolygonCCW
635
ST_IsPolygonCCW
FunctionSTIsPolygonCW
523
ST_IsPolygonCW
FunctionSTIsRing
644
ST_IsRing
FunctionSTIsSimple
247
ST_IsSimple
FunctionSTIsValid
151
ST_IsValid
FunctionSTIsValidDetail
138
ST_IsValidDetail
FunctionSTIsValidReason
280
ST_IsValidReason
FunctionSTIsValidTrajectory
405
ST_IsValidTrajectory
FunctionSTLength
330
ST_Length
FunctionSTLineFromText
544
ST_LineFromText
FunctionSTLineFromWKB
624
ST_LineFromWKB
FunctionSTLineInterpolateEquidistantPoints
278
ST_Line_Interpolate_Equidistant_Points
FunctionSTLineInterpolatePoint
441
ST_Line_Interpolate_Point
FunctionSTLineLocatePoint
190
ST_Line_Locate_Point
FunctionSTLineMerge
188
ST_LineMerge
FunctionSTLineStringFromText
197
ST_LineStringFromText
FunctionSTLineStringFromWKB
447
ST_LineStringFromWKB
FunctionSTLineSubstring
189
ST_Line_Substring
FunctionSTLinesCutAtNodes
304
ST_LinesCutAtNodes
FunctionSTLinesFromRings
501
ST_LinesFromRings
FunctionSTLinestringAvgSegmentLength
329
ST_LinestringAvgSegmentLength
FunctionSTLinestringMaxSegmentLength
570
ST_LinestringMaxSegmentLength
FunctionSTLinestringMinSegmentLength
192
ST_LinestringMinSegmentLength
FunctionSTLocateAlong
163
ST_LocateAlong
FunctionSTLocateAlongMeasure
560
ST_Locate_Along_Measure
FunctionSTLocateBetween
331
ST_LocateBetween
FunctionSTLocateBetweenMeasures
310
ST_Locate_Between_Measures
FunctionSTM
432
ST_M
FunctionSTMLineFromText
303
ST_MLineFromText
FunctionSTMLineFromWKB
361
ST_MLineFromWKB
FunctionSTMPointFromText
175
ST_MPointFromText
FunctionSTMPointFromWKB
469
ST_MPointFromWKB
FunctionSTMPolyFromText
490
ST_MPolyFromText
FunctionSTMPolyFromWKB
167
ST_MPolyFromWKB
FunctionSTMakePolygon
252
ST_MakePolygon
FunctionSTMaxM
287
ST_MaxM
FunctionSTMaxX
521
ST_MaxX
FunctionSTMaxY
257
ST_MaxY
FunctionSTMaxZ
594
ST_MaxZ
FunctionSTMinM
351
ST_MinM
FunctionSTMinX
340
ST_MinX
FunctionSTMinY
431
ST_MinY
FunctionSTMinZ
513
ST_MinZ
FunctionSTMulti
263
ST_Multi
FunctionSTMultiLineStringFromText
612
ST_MultiLineStringFromText
FunctionSTMultiLineStringFromWKB
336
ST_MultiLineStringFromWKB
FunctionSTMultiPointFromText
524
ST_MultiPointFromText
FunctionSTMultiPointFromWKB
325
ST_MultiPointFromWKB
FunctionSTMultiPolygonFromText
341
ST_MultiPolygonFromText
FunctionSTMultiPolygonFromWKB
227
ST_MultiPolygonFromWKB
FunctionSTNDims
204
ST_NDims
FunctionSTNPoints
214
ST_NPoints
FunctionSTNRings
634
ST_NRings
FunctionSTNumGeometries
457
ST_NumGeometries
FunctionSTNumInteriorRing
157
ST_NumInteriorRing
FunctionSTNumPoints
430
ST_NumPoints
FunctionSTOffsetCurve
338
ST_OffsetCurve
FunctionSTOverlaps
178
ST_Overlaps
FunctionSTPerimeter
320
ST_Perimeter
FunctionSTPoint
486
ST_Point
FunctionSTPointFromText
410
ST_PointFromText
FunctionSTPointFromWKB
506
ST_PointFromWKB
FunctionSTPointN
136
ST_PointN
FunctionSTPointOnSurface
169
ST_PointOnSurface
FunctionSTPolyFromText
326
ST_PolyFromText
FunctionSTPolyFromWKB
648
ST_PolyFromWKB
FunctionSTPolygonFromText
352
ST_PolygonFromText
FunctionSTPolygonFromWKB
596
ST_PolygonFromWKB
FunctionSTPolygonize
618
ST_Polygonize
FunctionSTRelate
356
ST_Relate
FunctionSTRelateMatch
481
ST_RelateMatch
FunctionSTRemovePoint
401
ST_RemovePoint
FunctionSTReverse
185
ST_Reverse
FunctionSTRingsCutAtNodes
423
ST_RingsCutAtNodes
FunctionSTSRID
503
ST_SRID
FunctionSTSetEndPoint
421
ST_SetEndPoint
FunctionSTSetPoint
253
ST_SetPoint
FunctionSTSetStartPoint
282
ST_SetStartPoint
FunctionSTSharedPaths
472
ST_SharedPaths
FunctionSTShiftLongitude
402
ST_Shift_Longitude
FunctionSTShortestLine
452
ST_ShortestLine
FunctionSTSimplify
319
ST_Simplify
FunctionSTSimplifyPreserveTopology
395
ST_SimplifyPreserveTopology
FunctionSTSingleSidedBuffer
305
ST_SingleSidedBuffer
FunctionSTSnap
493
ST_Snap
FunctionSTSnapToGrid
213
ST_SnapToGrid
FunctionSTSquareGrid
599
ST_SquareGrid
FunctionSTStartPoint
137
ST_StartPoint
FunctionSTSymDifference
279
ST_SymDifference
FunctionSTTouches
200
ST_Touches
FunctionSTTrajectoryInterpolatePoint
581
ST_TrajectoryInterpolatePoint
FunctionSTTransform
152
ST_Transform
FunctionSTTransformXY
321
ST_TransformXY
FunctionSTTransformXYZ
600
ST_TransformXYZ
FunctionSTTranslate
520
ST_Translate
FunctionSTTriangularGrid
413
ST_TriangularGrid
FunctionSTUnaryUnion
399
ST_UnaryUnion
FunctionSTUnion
235
ST_Union
FunctionSTUpDownHeight
396
ST_UpDownHeight
FunctionSTUphillHeight
665
ST_UphillHeight
FunctionSTVoronojDiagram
492
ST_VoronojDiagram
FunctionSTWKBToSQL
477
ST_WKBToSQL
FunctionSTWKTToSQL
242
ST_WKTToSQL
FunctionSTX
403
ST_X
FunctionSTY
239
ST_Y
FunctionSTZ
573
ST_Z
FunctionSanitizeGeometry
324
SanitizeGeometry
FunctionScaleCoordinates
429
ScaleCoordinates
FunctionScaleCoords
156
ScaleCoords
FunctionSecond
16
Second
FunctionSetEndPoint
444
SetEndPoint
FunctionSetPoint
629
SetPoint
FunctionSetSRID
584
SetSRID
FunctionSetStartPoint
534
SetStartPoint
FunctionSgn
72
Sgn
FunctionSharedPaths
364
SharedPaths
FunctionShiftCoordinates
608
ShiftCoordinates
FunctionShiftCoords
332
ShiftCoords
FunctionShortestLine
516
ShortestLine
FunctionSign
220
Sign
FunctionSimplify
664
Simplify
FunctionSimplifyPreserveTopology
614
SimplifyPreserveTopology
FunctionSin
50
Sin
FunctionSingleSidedBuffer
463
SingleSidedBuffer
FunctionSnap
177
Snap
FunctionSnapToGrid
548
SnapToGrid
FunctionSpace
689
Space
FunctionSpaceDollar
83
Space$
FunctionSpatialiteTargetCPU
479
spatialite_target_cpu
FunctionSpatialiteVersion
471
spatialite_version
FunctionSphericalArea
18
SphericalArea
FunctionSphericalObjectDistance
29
SphericalObjectDistance
FunctionSphericalObjectLen
24
SphericalObjectLen
FunctionSphericalPerimeter
21
SphericalPerimeter
FunctionSqliteSourceId
674
sqlite_source_id
FunctionSqliteVersion
116
Sqlite_Version
FunctionSqr
676
Sqr
FunctionSqrt
74
Sqrt
FunctionSquareGrid
632
SquareGrid
FunctionSridFromAuthCRS
488
SridFromAuthCRS
FunctionSridGetAxis1Name
638
SridGetAxis_1_Name
FunctionSridGetAxis1Orientation
342
SridGetAxis_1_Orientation
FunctionSridGetAxis2Name
337
SridGetAxis_2_Name
FunctionSridGetAxis2Orientation
435
SridGetAxis_2_Orientation
FunctionSridGetDatum
449
SridGetDatum
FunctionSridGetEllipsoid
545
SridGetEllipsoid
FunctionSridGetPrimeMeridian
392
SridGetPrimeMeridian
FunctionSridGetProjection
347
SridGetProjection
FunctionSridGetSpheroid
578
SridGetSpheroid
FunctionSridGetUnit
650
SridGetUnit
FunctionSridHasFlippedAxes
422
SridHasFlippedAxes
FunctionSridIsGeographic
354
SridIsGeographic
FunctionSridIsProjected
404
SridIsProjected
FunctionStartPoint
334
StartPoint
FunctionStddevPop
497
Stddev_pop
FunctionStddevSamp
455
Stddev_samp
FunctionStr
684
Str
FunctionStrDollar
42
Str$
FunctionStrFTime
108
StrFTime
FunctionString
690
String
FunctionStringCompare
60
StringCompare
FunctionStringDollar
84
String$
FunctionStringLocaleCompare
61
StringCompareIntl
FunctionStringToDate
85
StringToDate
FunctionSubstr
103
Substr
FunctionSubstring
104
Substring
FunctionSum
43
Sum
FunctionSwapCoordinates
621
SwapCoordinates
FunctionSwapCoords
143
SwapCoords
FunctionSymDifference
530
SymDifference
FunctionTableCoordSys
699
TableCoordSys
FunctionTan
425
Tan
FunctionTime
101
Time
FunctionTinyPointEncode
268
TinyPointEncode
FunctionToAxiGeo
67
ToAxiGeo
FunctionToGARS
572
ToGARS
FunctionToSLGeo
695
ToSLGeo
FunctionTotal
102
Total
FunctionTouches
271
Touches
FunctionTransform
249
Transform
FunctionTransformToAxiGeo
68
TransformToAxiGeo
FunctionTransformToSLGeo
700
TransformToSLGeo
FunctionTransformXY
473
TransformXY
FunctionTransformXYZ
633
TransformXYZ
FunctionTriangularGrid
343
TriangularGrid
FunctionTrim
100
Trim
FunctionTypeOf
107
TypeOf
FunctionUCase
679
UCase
FunctionUCaseDollar
33
UCase$
FunctionUnaryUnion
384
UnaryUnion
FunctionUncompressGeometry
314
UncompressGeometry
FunctionUnicode
110
Unicode
FunctionUnlikely
113
Unlikely
FunctionUpDownHeight
615
UpDownHeight
FunctionUphillHeight
366
UphillHeight
FunctionUpper
106
Upper
FunctionVal
41
Val
FunctionVarPop
348
Var_pop
FunctionVarSamp
652
Var_samp
FunctionVoronojDiagram
176
VoronojDiagram
FunctionWeekday
8
Weekday
FunctionWithin
54
CentroidWithin
FunctionWtAvg
75
WtAvg
FunctionWtAvgSafe
76
WtAvgSafe
FunctionX
502
X
FunctionXor
52
xor
FunctionY
658
Y
FunctionYear
7
Year
FunctionZ
458
Z
FunctionZeroBlob
118
ZeroBlob
FunctionNameCount
701
Общее число функций
-
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
) – Идентификатор функции- Результат
Название функции
- Тип результата