Has anyone found a PostgreSQL equivalent of Oracle's PERCENTILE_CONT function? I searched, and could not find one, so I wrote my own.

Here is the solution that I hope helps you out.

The company I work for wanted to migrate a Java EE web application from using an Oracle database over to using PostgreSQL. Several stored procedures relied heavily upon using Oracle's unique PERCENTILE_CONT() function. This function does not exist in PostgreSQL.

I tried searching to see if anyone had "ported over" that function into PG to no avail.

oracle-database function postgresql percentile
Edit
Report