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

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases

https://mimic.mit.edu

MIT License

2.62k stars 1.53k forks source link

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

Open liuhulangzw opened 1 month ago

liuhulangzw commented 1 month ago

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 commented 1 month ago

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

liuhulangzw commented 1 month ago

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

liuhulangzw commented 1 month ago

Postgresql, version 10

alistairewj commented 1 month ago

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!