Re: PostgreSQL needs percentage function

[Corey Taylor]

On Mon, Dec 18, 2017 at 11:01 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:

> ​Do you mean:
>
> SELECT id, val, val / (sum(val) OVER ())
> FROM vals;​
>


You could end up with a percentage > 100 or divide by 0 with that if the
values are not in a proper range.  I don't know if that would be the
intention.