Annotation: core.get_account_master_id_by_account_id

CREATE OR REPLACE FUNCTION core.get_account_master_id_by_account_id(bigint)
RETURNS integer

Information: core.get_account_master_id_by_account_id

Schema core
Function Name get_account_master_id_by_account_id
Arguments bigint
Owner postgres
Result Type integer
Description

Implementation: core.get_account_master_id_by_account_id

CREATE OR REPLACE FUNCTION core.get_account_master_id_by_account_id(bigint)
 RETURNS integer
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN core.accounts.account_master_id
    FROM core.accounts
    WHERE core.accounts.account_id= $1;
END
$function$