- 函数及兼容性
函数 | 是否ANSI扩展 | Greenplum |
Aggregate Functions | ||
AVG | ||
VAR_SAMP | ||
VAR_POP | ||
UNPIVOT | ||
SUM | ||
STDDEV_SAMP | ||
STDDEV_POP | ||
SKEW | ||
REGR_SYY | ||
REGR_SXY | ||
REGR_SXX | ||
REGR_SLOPE | ||
REGR_R2 | ||
REGR_INTERCEPT | ||
REGR_COUNT | ||
REGR_AVGY | ||
REGR_AVGX | ||
PIVOT | ||
MIN | ||
MAX | ||
KURTOSIS | ||
GROUPING | ||
COVAR_SAMP | ||
COVAR_POP | ||
COUNT | ||
CORR | ||
Attribute Functions | ||
BIT_LENGTH | ||
BYTES | ||
CHARACTER LENGTH | ||
DEFAULT | ||
FORMAT | ||
OCTET_LENGTH | ||
TITLE | ||
TYPE | ||
Bit/Byte Manipulation Functions | ||
BYTEINT | ||
SMALLINT | ||
INTEGER | ||
BIGINT | ||
BITAND | ||
BITNOT | ||
BITOR | ||
BITXOR | ||
COUNTSET | ||
GETBIT | ||
ROTATELEFT | ||
ROTATERIGHT | ||
SETBIT | ||
SHIFTLEFT | ||
SHIFTRIGHT | ||
SUBBITSTR | ||
TO_BYTE | ||
Built-In Functions | ||
ACCOUNT | ||
CURRENT_DATE/CURDATE | ||
CURRENT_ROLE | ||
CURRENT_TIME/CURTIME | ||
CURRENT_TIMESTAMP | ||
CURRENT_USER | ||
DATE | ||
NOW | ||
SESSION | ||
TEMPORAL_DATE | ||
TEMPORAL_TIMESTAMP | ||
TIME | ||
USER | ||
Comparison Operators and the Function | ||
DECODE | ||
GREATEST | ||
LEAST | ||
Null-Handling Functions | ||
NVL | ||
NVL2 | ||
Window Aggregate Functions | ||
CSUM | ||
CUME_DIST | ||
DENSE_RANK | ||
FIRST_VALUE / LAST_VALUE | ||
LAG/LEAD | ||
MAVG | ||
MDIFF | ||
MEDIAN | ||
MLINREG | ||
MSUM | ||
PERCENT_RANK | ||
PERCENTILE_CONT / PERCENTILE_DISC | ||
QUANTILE | ||
RANK (ANSI) | ||
ROW_NUMBER | ||
String Functions | ||
ASCII | ||
CHAR2HEXINT | ||
CONCAT | ||
CSV | ||
CSVLD | ||
EDITDISTANCE | ||
INDEX | ||
INITCAP | ||
INSTR | ||
LEFT | ||
LENGTH | ||
LOCATE | ||
LOWER | ||
LPAD | ||
LTRIM | ||
NGRAM | ||
NVP | ||
OREPLACE | ||
OTRANSLATE | ||
POSITION | ||
REVERSE | ||
RIGHT | ||
RPAD | ||
RTRIM | ||
SOUNDEX | ||
STRING_CS | ||
STRTOK | ||
STRTOK_SPLIT_TO_TABLE | ||
SUBSTRING/SUBSTR | ||
TRANSLATE | ||
TRANSLATE_CHK | ||
TRIM | ||
UPPER/UCASE | ||
VARGRAPHIC | ||