lt()#

relationalai.Producer
Producer.__lt__(other: Any) -> Expression

Returns an Expression that restricts Producer to values strictly less than other.

Parameters#

NameTypeDescription
otherAnyA numeric value or another Producer object.

Returns#

An Expression object.

Example#

The Producer.__lt__() method is called when you use the < operator with a Producer object:

import relationalai as rai

model = rai.Model("people")
Person = model.Type("Person")

with model.rule():
    Person.add(name="Fred", age=39)
    Person.add(name="Wilma", age=36)

with model.query() as select:
    person = Person()
    # Restrict `person.age` to values that are strictly less
    # than 39. `person.age` returns an `InstanceProperty` object,
    # which is also a `Producer` object.
    person.age < 39
    response = select(person.name, person.age)

print(response.results)
# Output:
#     name  age
# 0  Wilma   36

You may use < with two Producer objects:

with model.query() as select:
    person1, person2 = Person(), Person()
    person1.age < person2.age
    response = select(person1.name, person2.name)

print(response.results)
# Output:
#     name  name2
# 0  Wilma  Fred

See Also#