aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_nbis_clean_codes
Parameters
Name
Type
Mode
i_codes
text[]
IN
Definition
SELECT nullif(coalesce(( SELECT array_agg(btrim(t.raw) ORDER BY t.ord) FROM unnest(coalesce(i_codes, '{}'::text[])) WITH ORDINALITY AS t(raw, ord) WHERE nullif(btrim(t.raw), '') IS NOT NULL ), '{}'::text[]), '{}'::text[])