/custom-scripts

Custom SQL functions or scripts

Primary LanguagePLpgSQL

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