Alistair Johnson

OK, it's fairly challenging because I use Unix utilities to alter the scripts before passing them to the psql client. The .sh script (1) modifies the SQL files using a...

No the first step is absolutely required, and creates functions on postgresql you'll need. You can test if it worked with: `SELECT REGEXP_EXTRACT('test it grabs the number 123', '[0-9]+');` should...

> I have created functions on postgresql and they have appeared but couldn't be uesd. (I got 'No function matches the given name and argument types' after SELECT REGEXP_EXTRACT('test it...

OK, I managed to write a .bat file to generate the concepts on Windows. It requires WSL but is probably the most hands-free way of generating the concepts. It works...

> 1. When I tried to build 'weight_durations', it failed and said 'failed to find convertion from unkonw to text', which affected the creation of ‘heightweight’,'kdigo_uo' and some other views....

Yes - it was pretty hard to write a version of that query which is consistent for BigQuery/PostgreSQL. If you go back to an older version of mimic-code, then you...

Will take a look, thanks!

The plan is to include them but they are unavailable as of MIMIC-IV v0.4.

Thanks for the changes (and the other ones as well!). Which OS are you running this on? For the regexes, they are quite brittle as I'd like to support two...

I got way too distracted by other things and the MySQL container build - but yes especially with people running into issues (e.g. #1393) this should definitely be fixed... making...