DO $$
DECLARE
  itemcode varchar := 'IIII';

BEGIN

DROP TABLE IF EXISTS tmp_cust_table;

IF (select count (*) from Rdb_log_cust_account where Rdb_log_cust_account.sz_customer_no = itemcode) > 0
THEN
CREATE TABLE tmp_cust_table as
        select customer.sz_customer_no as "Customer_code",
        customer.SZ_CUSTOMER_FNAME as "Customer_fname",
        customer.sz_customer_lname as "Customer_lname",
        cust_account.n2_balance_value as "Customer_pointEarned",
        sum(Rdb_log_cust_account.N0_POINTS) as "Customer_pointUsed",
        customer.sz_cash_mobile_code as "Customer_mobyleNickname",
        customer.sz_email as "Customer_email"
        from  customer,cust_account, Rdb_log_cust_account
        where
                customer.sz_customer_no = itemcode and
                customer.sz_customer_no = cust_account.sz_customer_no and
                customer.sz_customer_no = Rdb_log_cust_account.sz_customer_no and
                Rdb_log_cust_account.sz_action ='ADD'
        group by
                customer.sz_customer_no,
                customer.SZ_CUSTOMER_FNAME,
                customer.sz_customer_lname,
                cust_account.n2_balance_value,
                cust_account.n2_balance_used,
                customer.sz_cash_mobile_code;

ELSE
CREATE TABLE tmp_cust_table as
        select customer.sz_customer_no as "Customer_code",
        customer.SZ_CUSTOMER_FNAME as "Customer_fname",
        customer.sz_customer_lname as "Customer_lname",
        cust_account.n2_balance_value as "Customer_pointEarned",0 as "Customer_pointUsed",
        customer.sz_cash_mobile_code as "Customer_mobyleNickname",
        customer.sz_email as "Customer_email"
        from  customer,cust_account
        where
                customer.sz_customer_no = @itemcode and
                customer.sz_customer_no = cust_account.sz_customer_no
        group by
                customer.sz_customer_no,
                customer.SZ_CUSTOMER_FNAME,
                customer.sz_customer_lname,
                cust_account.n2_balance_value,
                cust_account.n2_balance_used,
                customer.sz_cash_mobile_code;
END IF;
END; $$ LANGUAGE plpgsql;
