npmpackage.info

Gathering detailed insights and metrics for pg-range

Other packages similar to pg-range

pg-range-parser

1.0.0

Parses postgres range types

pg-range-datepicker

1.0.0

A datepicker (single or range) for your angular app.

pg-ballistics

1.0.1

Ballistics JavaScript Library (for calculating range cards)

pg-numrange

1.0.2

Built to help parse, work with, and create PostgreSQL compatible range strings.

Gathering detailed insights and metrics for pg-range

pg-range - 1.1.2 | npmpackage.info

pg-range

node-postgres plugin to parse tsrange, tstzrange, daterange columns

1.1.2

MIT

JavaScript

6.69 kB

2.3

Installations

npm install pg-range

Developer Guide

BETA

Typescript

Yes

Module System

CommonJS

Node Version

18.9.0

NPM Version

8.19.1 Pull Requests

Open

1

Total

8

Closed

2

Merged

5

Issues

Open

0

Total

8

Closed

8

Releases

Unable to fetch releases

Languages

JavaScript

Makefile

JavaScript (98.66%)

Makefile (1.34%)

Developer

WhoopInc

Download Statistics

Total Downloads

Last Day

Last Week

Last Month

Last Year

GitHub Statistics

MIT License

27 Stars

31 Commits

8 Forks

29 Watchers

2 Branches

4 Contributors

Updated on Jun 24, 2025

Maintainers

View All 4 Contributors

Package Meta Information

Latest Version

1.1.2

Package Id

pg-range@1.1.2

Unpacked Size

6.69 kB

Size

3.13 kB

File Count

NPM Version

8.19.1

Node Version

18.9.0

Total Downloads

Cumulative downloads

Total Downloads

NaN

Last Day

NaN

Compared to previous day

Last Week

NaN

Compared to previous week

Last Month

NaN

Compared to previous month

Last Year

NaN

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

@types/strange lodash.partial strange

Dev Dependencies

chai mocha pg sinon sinon-chai sinon-test

node-pg-range

Range type support for node-postgres.

Usage

Install pg-range into your existing pg adapter:

1var pg = require("pg");
2require("pg-range").install(pg);

Then make a query that returns range objects!

1client.query("SELECT range FROM table", function (result) {
2  // result.range = {
3  //   begin: Thu Mar 26 2014 17:57:02 GMT-0400 (EDT),
4  //   end: Thu Mar 27 2014 17:57:02 GMT-0400 (EDT),
5  //   bounds: '[)'
6  // }
7});

Or make a query that inserts range objects:

1var Range = require("pg-range").Range;
2
3client.query("INSERT INTO table VALUES ($1)", [Range(1, 3)]);

See the Postgres "Range Types" documentation for details.

Range objects

pg-range uses stRange.js, a JavaScript range library, to provide a Range class with useful methods, like contains and intersects. See the stRange.js API documentation.

Values of (PostgreSQL) type

int4range
int8range
numrange
tsrange
tstzrange
daterange

will be automatically parsed into instances of Range when the pg-range type adapter is installed.

Warning: When constructing range objects for use in queries, use the pg-range Range constructor as shown above, and not raw stRange.js Range objects. Raw stRange.js objects do not provide a toPostgres method, and will not properly serialize date ranges and empty ranges in queries!

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

License

Determines if the project has defined a license.

2

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

1

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

1

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

Maintained

Determines if the project is "actively maintained".

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

Fuzzing

Determines if the project uses fuzzing.

0

SAST

Determines if the project uses static code analysis.

Score

2.3

/10

Last Scanned on 2025-07-07

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More