aonestar.public

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

sp_get_address_lines

Parameters

Definition