hasura / hasura/graphql-engine

[FR] Support Increment/Decrement on Date/Time/Timestamp Fields

Open
#8,016 0 comments 0 reactions 0 assignees View on GitHub
k/enhancement
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

```
UPDATE table SET date_field = date_field + interval '1 year'
```

All these three can also be considered as numeric types, and postgres supports such operations, so why not
Currently I can only write a function and then the custom trackable function,
Or query before mutate,
it's a bit of ugly.

Contributor guide

Open the contributing guide

Research direction

No files or tests are named. Start by tracing how update mutations represent field changes and how PostgreSQL date, time, and timestamp values are validated, then review the existing custom-function and query-before-mutate paths. Done means the requested increment and decrement behavior is defined, implemented, and covered for the three temporal field types.

Written by the indexing model from the issue text.

Assessment

Tech stack
graphql, postgres
Domain
api, database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.