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

Open liuhulangzw opened this issue 1 year ago • 4 comments

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.

Oct 05 '24 08:10 liuhulangzw

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

Oct 05 '24 17:10 alistairewj

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

Oct 06 '24 11:10 liuhulangzw

Postgresql, version 10

Oct 10 '24 03:10 liuhulangzw

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!

Oct 10 '24 13:10 alistairewj