Referencia de funciones de PostgreSQL — SQL Academy

Funciones de cadena

CHAR_LENGTH CHR CONCAT CONCAT_WS FORMAT INITCAP LEFT LENGTH LOWER LPAD LTRIM OCTET_LENGTH POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPLIT_PART STRPOS SUBSTR SUBSTRING TRANSLATE TRIM UPPER

Funciones numéricas

ABS CEIL CEILING COS EXP FLOOR GREATEST LEAST LN LOG LOG10 MOD PI POWER RANDOM ROUND SIGN SIN SQRT TAN TRUNC

Funciones de fecha y hora

AGE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DATE DATE_PART DATE_TRUNC EXTRACT INTERVAL LOCALTIMESTAMP MAKE_DATE MAKE_INTERVAL MAKE_TIME NOW TO_CHAR TO_DATE TO_TIMESTAMP

Funciones de agregación

ARRAY_AGG AVG BOOL_AND BOOL_OR COUNT FILTER MAX MIN PERCENTILE_CONT PERCENTILE_DISC STDDEV_SAMP STRING_AGG SUM VAR_SAMP

Funciones de ventana

CUME_DIST DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD NTH_VALUE NTILE PERCENT_RANK RANK ROW_NUMBER ROWS BETWEEN

Funciones de expresiones regulares

REGEXP_COUNT REGEXP_INSTR REGEXP_LIKE REGEXP_MATCH REGEXP_MATCHES REGEXP_REPLACE REGEXP_SPLIT_TO_TABLE REGEXP_SUBSTR

Condiciones y construcciones

->->>::ARRAY_LENGTH CASE CAST COALESCE DISTINCT ON GENERATE_SERIES JSONB_BUILD_OBJECT JSONB_EXTRACT_PATH_TEXT NULLIF UNNEST WITH