custom-scripts

Custom SQL functions or scripts

Functions

Array

• array_distinct
• array_sort_and_unique
• array_accum

Datetime

• is_date_in_period
• ymd_to_dateminmax
• dateminmax_to_ymd

Parsing

• transform_ff_username
• remove_parentheses
• entity2char
• orcid_is_valid
• int_or_null
• uuid_or_null

Records

• rows_diff_jsonb

Remote

• http_get

Geometries

• ST_intersection_if_not_null