CREATE OR REPLACE FUNCTION public.get_single_customer(idparm integer)
RETURNS TABLE(id integer, first_name text, last_name text, business_name text, phone text, email text, address_one text, address_two text, city text, state text, zip text, country text, is_tax_exempt boolean, classification text)
LANGUAGE sql
AS $function$
SELECT
id, first_name, last_name, business_name, phone, email, address_one, address_two, city, state, zip, country, is_tax_exempt, classification
FROM
customer
FULL JOIN customer_private ON customer_private.customer_id = customer.id
WHERE customer.id = idParm
LIMIT 1
$function$
;
CREATE OR REPLACE FUNCTION public.get_single_customer(idparm integer)
RETURNS TABLE(id integer, first_name text, last_name text, business_name text, phone text, email text, address_one text, address_two text, city text, state text, zip text, country text, is_tax_exempt boolean, classification text)
LANGUAGE sql
AS $function$
SELECT
id, first_name, last_name, business_name, phone, email, address_one, address_two, city, state, zip, country, is_tax_exempt, classification
FROM
customer
FULL JOIN customer_private ON customer_private.customer_id = customer.id
WHERE customer.id = idParm
LIMIT 1
$function$
;