The use of interval types in PostgreSQL
- Dominant language
- Groovy
- Stars
- 2.9k
- Forks
- 975
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 92
Description
### Issue description
```
create table user_device_time
(
id bigserial
primary key,
version bigint,
device_id bigint,
user_id bigint,
user_type smallint,
time_range int8range
);
```
This is the table I created in PostgreSQL.
But the int8Range type doesn't map correctly during use, and I wonder if there is any processing in grails for this data type,Or is there any other way to deal with it
Contributor guide
Research direction
Start with the PostgreSQL schema in the issue and reproduce how the int8range column is handled in Grails. Trace the existing PostgreSQL type mapping and determine whether int8range is supported; done means the type maps correctly or the supported way to handle it is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- groovy, postgresql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100