pgtype icon indicating copy to clipboard operation
pgtype copied to clipboard

Support for multirange

Open danilobuerger opened this issue 4 years ago • 3 comments

Coming with postgres 14: https://www.postgresql.org/docs/14/rangetypes.html

Supported:

  • [x] int4range
  • [x] int8range
  • [x] numrange
  • [ ] tsrange
  • [ ] tstzrange
  • [ ] daterange

danilobuerger avatar Oct 11 '21 08:10 danilobuerger

Hi, I am actually trying to work on this feature - forgive my ignorance since I am new to this library, but how do you find the OID for these multirange types, say nummultirange , can it be assigned to any value?

VinhVu95 avatar Feb 17 '22 15:02 VinhVu95

Look in the pg_type table. e.g. select oid, typname from pg_type;

jackc avatar Feb 17 '22 16:02 jackc

Support for numeric, int4 and int8 types where added in #148

danilobuerger avatar Apr 01 '22 20:04 danilobuerger