Unsupported versions: 7.0
Historical version. PostgreSQL 7.0 has reached end of support. See the current manual.
Time Interval Operators
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 4-5. Postgres Time Interval Operators
| Operator | Description | Usage |
|---|---|---|
| #< | Interval less than? | |
| #<= | Interval less than or equal to? | |
| #<> | Interval not equal? | |
| #= | Interval equal? | |
| #> | Interval greater than? | |
| #>= | Interval greater than or equal to? | |
| <#> | Convert to time interval | |
| << | Interval less than? | |
| | | Start of interval | |
| ~= | Same as | |
| <?> | Time inside interval? |
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.