Annotation: transactions.is_valid_stock_transaction_by_transaction_master_id

CREATE OR REPLACE FUNCTION transactions.is_valid_stock_transaction_by_transaction_master_id(_transaction_master_id bigint)
RETURNS boolean

Information: transactions.is_valid_stock_transaction_by_transaction_master_id

Schema	transactions
Function Name	is_valid_stock_transaction_by_transaction_master_id
Arguments	_transaction_master_id bigint
Owner	postgres
Result Type	boolean
Description

Implementation: transactions.is_valid_stock_transaction_by_transaction_master_id

CREATE OR REPLACE FUNCTION transactions.is_valid_stock_transaction_by_transaction_master_id(_transaction_master_id bigint)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF EXISTS(SELECT * FROM transactions.stock_master WHERE transaction_master_id=$1) THEN
                RETURN true;
        END IF;

        RETURN false;
END
$function$