aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_address_lines
Parameters
Name
Type
Mode
addr
jsonb
IN
line1
text
OUT
line2
text
OUT
Definition
begin 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, '') ||IIF(soi is null and road is null and trok is null, coalesce(' '||subdistrict, ''), '')), trim(IIF(soi is null and road is null and trok is null, '', coalesce(' '||subdistrict, '')) ||coalesce(' '||district, '') ||coalesce(' '||province, '')) from A into line1, line2; end