Comparison

Aerospike comparison expressions allow you to evaluate values and return boolean results.

This guide explains operators like eq, ne, lt, gt, le, ge, cmp_regex, and cmp_geo. Code examples demonstrate how to implement these comparisons in database queries.

Ops

cmp_geo

cmp_geo(left, right)

Description

Returns true if the left is either contained within or contains the right.

Arguments

Name	Type
left	geojson_expr
right	geojson_expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find where bin ‘region’ contains a point.

c

const char* point = "<geojson point here>";
as_exp_build(predexp,
  as_exp_cmp_geo(as_exp_geo(point), as_exp_bin_geo("region")));

java

String point = "<geojson point here>";
Expression exp = Exp.build(
  Exp.geoCompare(Exp.geo(point), Exp.geoBin("region")));

cmp_regex

cmp_regex(regex_string, options_value, string)

Description

Returns true if the regex_string matches the string, otherwise returns false.

Arguments

Name	Type
regex_string	string_value
options_value	integer_value
string	string_expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find records where bin ‘phone_num’ contains area_code ‘555’.

c

as_exp_build(predexp,
  as_exp_cmp_regex("^555.*", 0, as_exp_bin_str("phone_num")));

java

Expression exp = Exp.build(
  Exp.regexCompare("^555.*", 0, Exp.stringBin("phone_num")));

eq

eq(left, right)

Description

Returns true if the left is equal to the right, otherwise returns false. left and right must result in the same fundamental type.

Arguments

Name	Type
left	expr
right	expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find records where bin ‘fname’ is equal to ‘Frank’.

c

as_exp_build(predexp,
  as_exp_cmp_eq(as_exp_bin_str("fname"), as_exp_str("frank")));

java

Expression exp = Exp.build(
  Exp.eq(Exp.stringBin("fname"), Exp.val("Frank")));

ge

ge(left, right)

Description

Returns true if the left is greater than or equal to the right, otherwise returns false. left and right must result in the same fundamental type.

Arguments

Name	Type
left	expr
right	expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find records where bin ‘age’ is greater than or equal to 21.

c

as_exp_build(predexp,
  as_exp_cmp_ge(as_exp_bin_int("age"), as_exp_int(21)));

java

Expression exp = Exp.build(
  Exp.ge(Exp.intBin("age"), Exp.val(21)));

gt

gt(left, right)

Description

Returns true if the left is greater than to the right, otherwise returns false. left and right must result in the same fundamental type.

Arguments

Name	Type
left	expr
right	expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find records where the time-to-live (TTL) is greater than 1 year.

c

as_exp_build(predexp,
  as_exp_cmp_gt(as_exp_ttl(), as_exp_int(365 * 24 * 3600)));

java

Expression exp = Exp.build(
  Exp.gt(Exp.ttl(), Exp.val(364 * 24 * 3600)));

le

le(left, right)

Description

Returns true if the left is less than or equal to the right, otherwise returns false. left and right must result in the same fundamental type.

Arguments

Name	Type
left	expr
right	expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find records where bin ‘balance’ is less than or equal to 100.

c

as_exp_build(predexp,
  as_exp_cmp_le(as_exp_bin_int("balance"), as_exp_int(100)));

java

Expression exp = Exp.build(
  Exp.le(Exp.intBin("balance"), Exp.val(100)));

lt

lt(left, right)

Description

Returns true if the left is less than the right, otherwise returns false. left and right must result in the same fundamental type.

Arguments

Name	Type
left	expr
right	expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find where bin ‘lname’ between ‘o’ and ‘p’.

c

as_exp_build(predexp,
  as_exp_and(
    as_exp_cmp_ge(as_exp_bin_str("lname"), as_exp_str("o"))
    as_exp_cmp_lt(as_exp_bin_str("lname"), as_exp_str("p"))));

java

Expression exp = Exp.build(
  Exp.and(
    Exp.ge(Exp.stringBin("lname"), Exp.val("o"))
    Exp.lt(Exp.stringBin("lname"), Exp.val("p"))));

ne

ne(left, right)

Description

Returns true if the left is not equal to the right, otherwise returns false. left and right must result in the same fundamental type.

Arguments

Name	Type
left	expr
right	expr

Returns

boolean_value

Introduced

5.2.0.4

Example

Find records where bin ‘age’ is not an integer.

c

as_exp_build(predexp,
  as_exp_cmp_ne(
    as_exp_bin_type("age"), as_exp_int(AS_BYTES_INTEGER)));

java

Expression exp = Exp.build(
  Exp.ne(Exp.binType("age"), Exp.val(ParticleType.INTEGER)