path: root/sql/modules/Account.sql

-- VERSION 1.3.0

CREATE OR REPLACE FUNCTION account_get (in_id) RETURNS chart AS
$$
DECLARE
    account chart%ROWTYPE
BEGIN
    SELECT * INTO account FROM chart WHERE id = in_id;
    RETURN account;
END;
$$ LANGAUGE plpgsql;

CREATE OR REPLACE FUNCTION account_is_orphaned (in_id) RETURNS bool AS
$$
BEGIN
    SELECT trans_id FROM acc_trans WHERE chart_id = in_id LIMIT 1;
    IF FOUND THEN
        RETURN true;
    ELSE
        RETURN false;
    END IF;
END;
$$ LANGUAGE plpgsql;