aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_format_address
Parameters
Name
Type
Mode
addr
jsonb
IN
Definition
with A as ( Select nullif(trim(addr ->> 'addr_no'),'') as addr_no, nullif(trim(addr ->> 'moo'),'') as moo, nullif(trim(addr ->> 'trok'),'') as trok, nullif(trim(addr ->> 'soi'),'') as soi, nullif(trim(addr ->> 'road'),'') as road, nullif(trim(addr ->> 'subdistrict'),'') as subdistrict, nullif(trim(addr ->> 'district'),'') as district, nullif(trim(addr ->> 'province'),'') as province ) select trim(coalesce(addr_no, '') ||coalesce(' '||moo, '') ||coalesce(' '||trok, '') ||coalesce(' '||soi, '') ||coalesce(' '||road, '') ||coalesce(' '||subdistrict, '') ||coalesce(' '||district, '') ||coalesce(' '||province, '') ) from A