PHPackages                             sunaoka/laravel-postgres-range - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. sunaoka/laravel-postgres-range

ActiveLibrary[Database & ORM](/categories/database)

sunaoka/laravel-postgres-range
==============================

PostgreSQL Range Types for Laravel.

v2.4.0(4mo ago)210.9k↓37%1MITPHPPHP ^8.1CI passing

Since Apr 23Pushed 4mo ago1 watchersCompare

[ Source](https://github.com/sunaoka/laravel-postgres-range)[ Packagist](https://packagist.org/packages/sunaoka/laravel-postgres-range)[ RSS](/packages/sunaoka-laravel-postgres-range/feed)WikiDiscussions develop Synced 1mo ago

READMEChangelogDependencies (6)Versions (12)Used By (1)

PostgreSQL Range Types for Laravel 8.x to 12
============================================

[](#postgresql-range-types-for-laravel-8x-to-12)

[![Latest Stable Version](https://camo.githubusercontent.com/4edaf8477ff8529691691a895bfdc3af14a2e13ee67ca0d3ad1f2caa1bae1169/68747470733a2f2f706f7365722e707567782e6f72672f73756e616f6b612f6c61726176656c2d706f7374677265732d72616e67652f762f737461626c65)](https://packagist.org/packages/sunaoka/laravel-postgres-range)[![License](https://camo.githubusercontent.com/16fcbc7330edbb5ce31710fd83b4f99e5fc2a6b7d55029d840259d8be9750b1b/68747470733a2f2f706f7365722e707567782e6f72672f73756e616f6b612f6c61726176656c2d706f7374677265732d72616e67652f6c6963656e7365)](https://packagist.org/packages/sunaoka/laravel-postgres-range)[![PHP from Packagist](https://camo.githubusercontent.com/5b6d2f3e462ae77c4d574f853323f3ca1a12c51a2d9055002ab2aa7e2e498d9f/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f7068702d762f73756e616f6b612f6c61726176656c2d706f7374677265732d72616e6765)](composer.json)[![Laravel](https://camo.githubusercontent.com/ef2b039fe6ed869a837c821c6fd07179f42860583d6e37a26c486fcc82a95880/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c61726176656c2d2533453d253230382e782d726564)](https://laravel.com/)[![Test](https://github.com/sunaoka/laravel-postgres-range/actions/workflows/test.yml/badge.svg)](https://github.com/sunaoka/laravel-postgres-range/actions/workflows/test.yml)[![codecov](https://camo.githubusercontent.com/d93478cfd9f8cdfba1c1ab121db03b94fdb3d7e1600b00f792a72ff7a799847e/68747470733a2f2f636f6465636f762e696f2f67682f73756e616f6b612f6c61726176656c2d706f7374677265732d72616e67652f6272616e63682f646576656c6f702f67726170682f62616467652e737667)](https://codecov.io/gh/sunaoka/laravel-postgres-range)

---

Installation
------------

[](#installation)

```
composer require sunaoka/laravel-postgres-range
```

Features
--------

[](#features)

- Range Types
    - int4range — Range of integer
    - int8range — Range of bigint
    - numrange — Range of numeric
    - tsrange — Range of timestamp without time zone
    - tstzrange — Range of timestamp with time zone
    - daterange — Range of date

Usage
-----

[](#usage)

### Table

[](#table)

```
CREATE TABLE tests (
  id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  ts_range tsrange,
  ts_tz_range tstzrange,
  date_range daterange,
  int4_range int4range,
  int8_range int8range,
  num_range numrange,
  created_at timestamp,
  updated_at timestamp
);
```

### Model

[](#model)

```