Hi,
I am trying to compare two variable in basex as given,
let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return $v2 <= $v3
I am expecting that it will give me true, But it is giving false. I think it is because of the comparison is only string comparison. Is it possible to configure basex for numeric comparison without changing the expression $V2 <= $V3 , or I have to explicitly convert variable value to decimal and then compare it.
Thanks, Ankit
Simply convert the values to numbers:
let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return number($v2) <= number($v3)
Best, Christian
On Wed, May 13, 2015 at 9:40 AM, ankit kumar anky4bugs@gmail.com wrote:
Hi,
I am trying to compare two variable in basex as given,
let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return $v2 <= $v3
I am expecting that it will give me true, But it is giving false. I think it is because of the comparison is only string comparison. Is it possible to configure basex for numeric comparison without changing the expression $V2 <= $V3 , or I have to explicitly convert variable value to decimal and then compare it.
Thanks, Ankit
basex-talk@mailman.uni-konstanz.de