Annotation: core.get_shipping_address_by_shipping_address_id

CREATE OR REPLACE FUNCTION core.get_shipping_address_by_shipping_address_id(bigint)
RETURNS text

Information: core.get_shipping_address_by_shipping_address_id

Schema	core
Function Name	get_shipping_address_by_shipping_address_id
Arguments	bigint
Owner	postgres
Result Type	text
Description

Implementation: core.get_shipping_address_by_shipping_address_id

CREATE OR REPLACE FUNCTION core.get_shipping_address_by_shipping_address_id(bigint)
 RETURNS text
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF($1 IS NULL OR $1 <=0) THEN
                RETURN '';
        END IF;


        RETURN
                core.append_if_not_null(po_box, '<br />') || 
                core.append_if_not_null(address_line_1, '<br />') || 
                core.append_if_not_null(address_line_2, '<br />') || 
                core.append_if_not_null(street, '<br />') ||
                city  || '<br />' ||
                state  || '<br />' ||
                country 
        FROM core.shipping_addresses
        WHERE shipping_address_id=$1;
        
END
$function$