- 函数及兼容性
| 函数 | 是否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 | ||
531
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
