Annotation: transactions.get_transaction_master_id_by_stock_master_id

CREATE OR REPLACE FUNCTION transactions.get_transaction_master_id_by_stock_master_id(_stock_master_id bigint)
RETURNS bigint

Information: transactions.get_transaction_master_id_by_stock_master_id

Schema	transactions
Function Name	get_transaction_master_id_by_stock_master_id
Arguments	_stock_master_id bigint
Owner	postgres
Result Type	bigint
Description

Implementation: transactions.get_transaction_master_id_by_stock_master_id

CREATE OR REPLACE FUNCTION transactions.get_transaction_master_id_by_stock_master_id(_stock_master_id bigint)
 RETURNS bigint
 LANGUAGE plpgsql
AS $function$
BEGIN
        RETURN
        (
                SELECT transactions.stock_master.transaction_master_id
                FROM transactions.stock_master
                WHERE transactions.stock_master.stock_master_id=$1
        );
END
$function$