Opaleye.Operators

Restriction operators

restrict

keepWhen

Equality operators

(.==)

(./=)

(.===)

(./==)

Comparison operators

(.>)

(.<)

(.<=)

(.>=)

Numerical operators

quot_

rem_

Conditional operators

case_

ifThenElse

ifThenElseMany

Logical operators

(.||)

(.&&)

not

ors

Text operators

(.++)

lower

upper

like

ilike

charLength

Containment operators

in_

inQuery

JSON operators

class PGIsJson a

class PGJsonIndex a

(.->)

(.->>)

(.#>)

(.#>>)

(.@>)

(.<@)

(.?)

(.?|)

(.?&)

Other operators

timestamptzAtTimeZone

emptyArray

arrayPrepend

singletonArray

doubleOfInt

overlap

(.<<)

(.>>)

(.&<)

(.&>)

(.-|-)