Support for Range Types

[andre1sk]

One of really nice features of PostgreSQL is range types:
tsrange — Range of timestamp without time zone
tstzrange — Range of timestamp with time zone
daterange — Range of date
int4range — Range of integer
int8range — Range of bigint
numrange — Range of numeric
https://www.postgresql.org/docs/current/rangetypes.html
would be nice to add support for them. I have time to work on this but it prob. requires a bit of discussion on TS types we would want to create for this @bartlomieju ?

[bartlomieju]

Very good idea @andre1sk! I'll need some time to work through the types solution, but feel free to open a PR with prototype so we can iterate.

EDIT: quick search for Range type in TS:
https://github.com/kgtkr/typepark/blob/master/src/list.ts#L47-L50

export type Range<A extends number, B extends number, R extends any[] = []> = {
  0: Reverse<Cons<A, R>>,
  1: Range<Inc<A>, B, Cons<A, R>>
}[A extends B ? 0 : 1];

Looks like a good starting point

[bartlomieju]

@andre1sk any update on this issue?

[bombillazo]

node-postgres uses https://github.com/martianboy/postgres-range to handle these, worth taking a look