Re: PostgreSQL needs percentage function

Edson Carlos Ericksson Richter <richter@xxxxxxxxxxxxxx> · Mon, 18 Dec 2017 15:08:14 -0200



    Em 18/12/2017 15:01, David G. Johnston
      escreveu:

    
        On Mon, Dec 18, 2017 at
            9:56 AM, Edson Carlos Ericksson Richter <richter@xxxxxxxxxxxxxx> wrote:

        
                    But, is it possible
                        to have a aggregate function that calculates de
                        percent from the sum (and/or count) total (as a
                        value from 0 ... 1) for numeric (or double)?

                    
          Do you mean:
          

          SELECT id,
            val, val / (sum(val) OVER ())
          FROM vals;
        
        
          David J.
          

    I've never thought about Window Functions that way.

    Thanks, it is enligthning.

    
    :-)

    
    Regards,

    
    Edson.