Introduction

Get started with commonly-used Postgres functions with SerenDB's function guides. For other functions that Postgres supports, visit the official Postgres Functions and Operators documentation.

Aggregate functions

array_agg()

avg()

count()

max()

sum()

Array functions

array_length()

Date / Time functions

age()

current_timestamp

date_trunc()

extract()

now()

JSON functions

array_to_json()

json()

json_agg()

json_array_elements()

jsonb_array_elements()

json_build_object()

json_each()

json_exists()

json_extract_path()

json_extract_path_text()

json_object()

json_populate_record()

json_query()

json_scalar()

json_serialize()

json_table()

json_to_record()

json_value()

jsonb_each()

jsonb_extract_path()

jsonb_extract_path_text()

jsonb_object()

jsonb_populate_record()

jsonb_to_record()

Mathematical functions

abs()

random()

round()

String functions

concat()

lower()

substring()

regexp_match()

regexp_replace()

trim()

Window functions

dense_rank()

lag()

lead()

rank()