Home > mailing lists

[GENERAL] Average - Pg 9.2 - Mailing list pgsql-general

From	Patrick B
Subject	[GENERAL] Average - Pg 9.2
Date	February 3, 2017 09:19:27
Msg-id	CAJNY3iuhVuW=C1ijb-6=ptxLvDfBi+6jwNqcgNUHQfgpG7ZxAA@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] Average - Pg 9.2 ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-general

Hi guys,

I've got a table which has id and created date columns.

I want to get the average of inserted rows monthly.

How can I get this data?

This query is not working as it is showing me same data in both columns.

select created_date,

AVG(id)

OVER(ORDER BY created_date) AS avr from test

Thanks!
Patrick

From: Michael Paquier
Date: 03 February 2017, 08:34:36
Subject: Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout

From: "David G. Johnston"
Date: 03 February 2017, 09:54:01
Subject: Re: [GENERAL] Average - Pg 9.2