Up: Column Types
Next: Strings >

Column Types: Numbers

The sq representation of all numeric types (INT, FLOAT, etc) is the NumberField. You can convert an int, int64 or float64 into a NumberField:
func Int(num int) NumberField
func Int64(num int64) NumberField
func Float64(num float64) NumberField
Here are the available Predicate operations on a NumberField:
func (f NumberField) IsNull() Predicate          // f IS NULL
func (f NumberField) IsNotNull() Predicate       // f IS NOT NULL
func (f NumberField) In(v interface{}) Predicate // f IN (v)

// NumberField
func (f NumberField) Eq(field NumberField) Predicate // f = field
func (f NumberField) Ne(field NumberField) Predicate // f <> field
func (f NumberField) Gt(field NumberField) Predicate // f > field
func (f NumberField) Ge(field NumberField) Predicate // f >= field
func (f NumberField) Lt(field NumberField) Predicate // f < field
func (f NumberField) Le(field NumberField) Predicate // f <= field

// int
func (f NumberField) EqInt(num int) Predicate // f = num
func (f NumberField) NeInt(num int) Predicate // f <> num
func (f NumberField) GtInt(num int) Predicate // f > num
func (f NumberField) GeInt(num int) Predicate // f >= num
func (f NumberField) LtInt(num int) Predicate // f < num
func (f NumberField) LeInt(num int) Predicate // f <= num

// int64
func (f NumberField) EqInt64(num int64) Predicate // f = num
func (f NumberField) NeInt64(num int64) Predicate // f <> num
func (f NumberField) GtInt64(num int64) Predicate // f > num
func (f NumberField) GeInt64(num int64) Predicate // f >= num
func (f NumberField) LtInt64(num int64) Predicate // f < num
func (f NumberField) LeInt64(num int64) Predicate // f <= num

// float64
func (f NumberField) EqFloat64(num float64) Predicate // f = num
func (f NumberField) NeFloat64(num float64) Predicate // f <> num
func (f NumberField) GtFloat64(num float64) Predicate // f > num
func (f NumberField) GeFloat64(num float64) Predicate // f >= num
func (f NumberField) LtFloat64(num float64) Predicate // f < num
func (f NumberField) LeFloat64(num float64) Predicate // f <= num
Up: Column Types
Next: Strings >