Annotation: transactions.contains_incompatible_taxes

CREATE OR REPLACE FUNCTION transactions.contains_incompatible_taxes(VARIADIC arr bigint[])
RETURNS boolean

Information: transactions.contains_incompatible_taxes

Schema	transactions
Function Name	contains_incompatible_taxes
Arguments	VARIADIC arr bigint[]
Owner	postgres
Result Type	boolean
Description

Implementation: transactions.contains_incompatible_taxes

CREATE OR REPLACE FUNCTION transactions.contains_incompatible_taxes(VARIADIC arr bigint[])
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF
    (
        SELECT COUNT(DISTINCT non_taxable) FROM transactions.non_gl_stock_master
        WHERE non_gl_stock_master_id = any($1)
    ) > 1 THEN
        RETURN true;
    END IF;

    RETURN false;
END
$function$