From PostgreSQL wiki
- TIMESTAMP - already in PostgreSQL
- INTERVAL - already in PostgreSQL
- PERIOD(TIME) and PERIOD(TIME WITH TIMEZONE)
- PERIOD(TIMESTAMP) and PERIOD(TIMESTAMP WITH TIMEZONE)
- PERIOD(INT) and PERIOD(INTEGER)
- PERIOD(NUMERIC) - only with scale 0
- PERIOD(DECIMAL) - only with scale 0
Since the TIMESTAMP and INTERVAL types are in PostgreSQL, this information will focus on the PERIOD types.
In the following operators, p and q are PERIODs and i is an INTERVAL.
- p = q
- p PRECEDES q
- p SUCCEEDS q
* initial RFC - contains a lot of details and further references