CREATE TYPE ctu_customer_list AS
   (customerid character( 14 ),
    parentid character( 14 ));
ALTER TYPE ctu_customer_list OWNER TO postgres;

CREATE OR REPLACE FUNCTION cur_customer_list(pc_customerid bpchar)
  RETURNS SETOF ctu_customer_list AS
$BODY$  DECLARE c_customerid CHAR( 14 );
  DECLARE c_parentid CHAR( 14 );
BEGIN 

c_customerid:=pc_customerid;


SELECT CustomerID, ParentID INTO c_customerid, c_parentid FROM customer 
	WHERE CustomerID=c_customerid;
IF FOUND THEN
	--Записываем в результат главную фирму
        RETURN QUERY SELECT CustomerID, ParentID FROM customer 
                WHERE CustomerID=c_customerid;
        RETURN QUERY SELECT CustomerID, ParentID FROM customer 
                WHERE ParentID=c_customerid;
END IF;
RETURN;
END
$BODY$
  LANGUAGE 'plpgsql' VOLATILE