................................................................................496 31.8.4. The interval type .......................................................................................... SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be containment 31 Chapter 4. SQL Syntax Operator/Element Associativity Description OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching < > less than, greater than = right equality

......................119 8.5.4. Interval Input.....................................................................................................120 8.5.5. Interval Output.......................... ................................................................................654 32.8.4. The interval type .......................................................................................... SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be

.........................112 8.5.4. Interval Input..............................................................................................114 8.5.5. Interval Output.............................. ................................................................................615 32.8.4. The interval type ......................................................................................619 32 SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be

................................................................................496 31.8.4. The interval type .......................................................................................... SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be containment 31 Chapter 4. SQL Syntax Operator/Element Associativity Description OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching < > less than, greater than = right equality

...................... 160 8.16. ISO 8601 Interval Unit Abbreviations .................................................................... 162 8.17. Interval Input .................................... ................................................................. 162 8.18. Interval Output Style Examples ............................................................................ 163 8.19. Boolean SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be

.................... 167 8.16. ISO 8601 Interval Unit Abbreviations ......................................................................... 170 8.17. Interval Input ................................. ......................................................................... 171 8.18. Interval Output Style Examples .................................................................................. 172 SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be

................................................................................585 32.8.4. The interval type .......................................................................................... SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be containment 31 Chapter 4. SQL Syntax Operator/Element Associativity Description OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching < > less than, greater than = right equality

................................................................................552 32.8.4. The interval type ......................................................................................556 32 SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types. PostgreSQL can be other native and user-defined operators IN set membership BETWEEN range containment OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching < > less than, greater than = right equality

......................133 8.5.4. Interval Input.....................................................................................................134 8.5.5. Interval Output.......................... timestamp, date......................................................................770 33.4.4.2.2. interval ...................................................................................771 33.4.4.2 ................................................................................791 33.6.5. The interval Type ..........................................................................................

.........................125 8.5.4. Interval Input..............................................................................................127 8.5.5. Interval Output.............................. 1. timestamp, date...............................................................729 33.4.4.2.2. interval ............................................................................729 33.4.4.2.3. numeric ................................................................................748 33.6.5. The interval Type .....................................................................................751 33