aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_match_value
Parameters
Name
Type
Mode
oper
text
IN
left_value
integer
IN
right_value
integer
IN
Definition
SELECT (right_value = -1 and coalesce(left_value,0) > 0) or (oper = '>' and coalesce(left_value,0) > right_value) or (oper = '<' and coalesce(left_value,0) < right_value) or (oper = '=' and coalesce(left_value,0) = right_value) or (oper = '>=' and coalesce(left_value,0) >= right_value) or (oper = '<=' and coalesce(left_value,0) <= right_value)