lets say that i have a column in one of my tables:
initial_odometer_reading (type is decimal), which for any particular
record, may or may not be set by the user of the application.
somewhere in my code, i want to search for those records for which the
user has set/initialized this column.
how do i do so, properly?
i can set the default value in the ‘create table’ method to be ‘-1’
and then query for ‘-1’, this works, but doesn’t seem right. i want to
do the right thing here.
what is the conventional way to solve this?
note that zero is a legitimate value to which the user may set the