WHERE owner = ANY ($2)
AND BTRIM('||sc||') = BTRIM(name)
) AND value = BTRIM('||sce||')
+ AND owner = ANY ($2)
)
AND NOT EXISTS (
SELECT id
WHERE owner = ANY ($2)
AND BTRIM('||sc||') = BTRIM(name)
) AND value = BTRIM('||sce||')
+ AND owner = ANY ($2)
)
ORDER BY 1,3;'
USING org, org_list;
WHERE owner = ANY ($2)
AND BTRIM('||sc||') = BTRIM(name)
) AND value = BTRIM('||sce||')
+ AND owner = ANY ($2)
)
AND NOT EXISTS (
SELECT id
WHERE owner = ANY ($2)
AND BTRIM('||sc||') = BTRIM(name)
) AND value = BTRIM('||sce||')
+ AND owner = ANY ($2)
)
ORDER BY 1,3;'
USING org, org_list;