Method: Sequel::Dataset#avg

Defined in:
lib/sequel/dataset/actions.rb

#avg(arg = (no_arg = true), &block) ⇒ Object

Returns the average value for the given column/expression. Uses a virtual row block if no argument is given.

DB[:table].avg(:number) # SELECT avg(number) FROM table LIMIT 1
# => 3
DB[:table].avg{function(column)} # SELECT avg(function(column)) FROM table LIMIT 1
# => 1



82
83
84
85
 
# File 'lib/sequel/dataset/actions.rb', line 82

def avg(arg=(no_arg = true), &block)
  arg = Sequel.virtual_row(&block) if no_arg
  _aggregate(:avg, arg)
end