How to post range type?

[morfair]

How to POST range data types like this?

SELECT daterange('2021-09-01', '2021-09-15', '[]');

SELECT '[2021-09-01, 2021-09-15]'::daterange;

[steve-chavez]

Here's an example using a numrange

create table ranges (
    id integer primary key,
    range numrange
);

http POST 'localhost:3000/ranges' <<JSON
{"id": 5, "range": "(15,21]"}
JSON

http GET 'localhost:3000/ranges?id=eq.5'

[
    {
        "id": 5,
        "range": "(15,21]"
    }
]

[morfair]

Ok, thanks!
Another question is how to send an array of ranges?

SELECT ARRAY[ daterange('2021-09-01', '2021-09-15', '[]'), daterange('2021-09-16', '2021-09-30', '[]') ];

[steve-chavez]

Same idea, as long as pg is able to cast a literal representation:

select '{"(15,21]","(22,30]"}'::numrange[];
┌───────────────────────┐
│       numrange        │
├───────────────────────┤
│ {"(15,21]","(22,30]"} │
└───────────────────────┘

Then the same literal representation should work through PostgREST:

create table ranges2 (
    id integer primary key,
    ranges numrange[]
);

http POST l:3000/ranges2 <<JSON
{"id": 1, "ranges": ["(15,21]", "(23,24]"]}
JSON