MSQL Reference – Compound



Overview
- About SpaceTime Cluster
  - Cluster Components
- Release Notes
How-to Guides
- Getting Started with MSQL
MSQL Syntax
Data Types
Operator Reference
Function Reference
- Generic Functions
  - ABS
  - CAST
  - COALESCE
  - IFNOTNULL
  - NULLIF
  - IF
  - GREATEST
  - LEAST
  - MAXIMUM
  - MINIMUM
  - SIGN
- Aggregate Functions
  - AVG
  - COUNT
  - SUM
  - MAX
  - MIN
  - ANY_VALUE
  - BIT_AND
  - BIT_OR
  - BIT_XOR
  - STRING_AGG
  - BOOL_AND
  - BOOL_OR
  - CORR
  - COVAR_POP
  - COVAR_SAMP
  - STDDEV_POP
  - STDDEV_SAMP
  - VAR_POP
  - VAR_SAMP
  - REGR_AVGX
  - REGR_AVGY
  - REGR_COUNT
  - REGR_INTERCEPT
  - REGR_R2
  - REGR_SLOPE
  - REGR_SXX
  - REGR_SXY
  - REGR_SYY
- Mathematical Functions
  - PI
  - DEGREES
  - RADIANS
  - CEIL
  - FLOOR
  - ROUND
  - TRUNC
  - FMOD
  - CBRT
  - EXP
  - LN
  - LOG10
  - LOG2
  - POWER
  - SQRT
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - COS
  - SIN
  - TAN
  - ACOSH
  - ASINH
  - ATANH
  - COSH
  - SINH
  - TANH
  - RANDINT
  - RANDOM
- String Functions
  - CHAR_LENGTH
  - OCTET_LENGTH
  - LENGTH
  - STARTS_WITH
  - ENDS_WITH
  - POSITION
  - CHR
  - ORD
  - STRCMP
  - CONCAT
  - CONCAT_WS
  - LOWER
  - UPPER
  - INITCAP
  - BTRIM
  - LTRIM
  - RTRIM
  - LPAD
  - RPAD
  - REPEAT
  - REPLACE
  - REVERSE
  - SUBSTRING
  - LEFT
  - RIGHT
  - SPLIT_PART
  - JSON_ESCAPE
  - TRANSLATE
  - FORMAT
  - TO_CHAR
  - PARSE_BOOL
  - PARSE_FLOAT
  - PARSE_INT
  - HEX_ENCODE
  - HEX_DECODE
  - BASE64_ENCODE
  - BASE64_DECODE
- Range Functions
  - RANGE
  - LBOUND
  - RBOUND
  - RDISTANCE
  - REXPAND
  - RNORMALIZE
  - RSPAN
  - RVALID
  - DURATION
  - LERP
  - MIDPOINT
- Temporal Functions
  - CURRENT_TS
  - CURRENT_TZ
  - PARSE_EPOCH
  - PARSE_TP
  - PARSE_TS
  - PARSE_TSRANGE
  - PARSE_EPOCHRANGE
  - TO_CHAR (temporal)
  - TS_ADDM
  - TS_BUCKET
  - TS_DATE
  - TS_DATETIME
  - TS_EXTRACT
  - TS_SUBM
  - TS_TRUNC
  - TS_DAYSTART
  - TS_WEEKSTART
  - TS_ISOWEEKSTART
  - TS_MONTHSTART
  - TS_YEARSTART
  - TS_TIMEOFDAY
  - NOW
  - TODAY
  - YESTERDAY
  - YEAR
  - MONTH
  - DAY
  - HOUR
  - MINUTE
  - SECOND
  - MILLISECOND
  - WEEK
  - ISOWEEK
  - DOW
  - ISODOW
  - DOY
  - YEARS
  - MONTHS
  - WEEKS
  - DAYS
  - HOURS
  - MINUTES
  - SECONDS
  - MILLISECONDS
- Spatial Functions - Constructors
- Spatial Functions - Conversions
- Spatial Functions - Accessors
  - ST_BOUNDARY
  - ST_GEOMETRYTYPE
  - ST_MEMSIZE
  - ST_NPOINTS
  - ST_ISEMPTY
  - ST_ISSIMPLE
  - ST_ISVALID
  - ST_ISVALIDREASON
  - ST_X
  - ST_Y
  - ST_NUMPOINTS
  - ST_POINTN
  - ST_STARTPOINT
  - ST_ENDPOINT
  - ST_EXTERIORRING
  - ST_NUMINTERIORRINGS
  - ST_INTERIORRINGN
  - ST_NUMGEOMETRIES
  - ST_GEOMETRYN
  - ST_ENVELOPE
  - ST_EXPAND
  - ST_XMAX
  - ST_XMIN
  - ST_YMAX
  - ST_YMIN
- Spatial Functions - Predicates
- Spatial Functions - Measurements
- Spatial Functions - Processing
- Coordinate Conversion Functions
  - TO_METERS
  - TO_WORLD
  - TO_LAT
  - TO_LON
  - TO_WPX
  - TO_WPY
- Table-Valued Functions
MSQL Internals
- Catalog

Compound types aren't yet supported, but will be soon, stay tuned!

Spatial

Type Aliases & Conversions

Spatial

Back to Top

Type Aliases & Conversions

Copyright © Mireo 2015-2022