mkt

Mean kinetic temperature aggregate function for postgres

input and output temperature in celsius

installation

[Linux]

1. open your terminal an type

  psql -h localhost -U postgres < MKT_function.sql

Usage example

CREATE TABLE data(temp numeric);
INSERT INTO data VALUES (2), (2), (5), (8),(8),(8),(8);

select mkt(temp) from data;

Result

mkt  
------
 6.25

External links

Wikipedia Temperatura cinética media