The time interval data type tinterval is a legacy from the original date/time types and is not as well supported as the more modern types. There are several operators for this type.
Table 9-5. Postgres Time Interval Operators
|#<||Interval less than?|
|#<=||Interval less than or equal to?|
|#<>||Interval not equal?|
|#>||Interval greater than?|
|#>=||Interval greater than or equal to?|
|<#>||Convert to time interval|
|<<||Interval less than?|
||||Start of interval|
|<?>||Time inside interval?|
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.