Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Questions about kdigo_uo.sql for function RANGE BETWEEN PRECEDING AND CURRENT ROW #1810

Open
liuhulangzw opened this issue Oct 5, 2024 · 4 comments
Open

Questions about kdigo_uo.sql for function RANGE BETWEEN PRECEDING AND CURRENT ROW #1810

liuhulangzw opened this issue Oct 5, 2024 · 4 comments

Comments

@liuhulangzw
Copy link

When I run kdigo_uo.sql, errors may occur: UNBOUNDED cannot support RANGE PRECEDING.
I don't understand if there is any problem with the use of the function.
Thank you all for your answers.
@alistairewj
Copy link
Member

What version of postgresql are you using? Or are you using a different RDBMS?

@liuhulangzw
Copy link
Author

What version of postgresql are you using? Or are you using a different RDBMS?
Postgresql, version 10

@liuhulangzw
Copy link
Author

Postgresql, version 10

@alistairewj
Copy link
Member

The query works on PostgreSQL 12, so I would try to upgrade. I think full range date functionality was implemented later than 10. PostgreSQL 10 is unsupported now so you probably want to upgrade anyway!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alistairewj @liuhulangzw