Re: Moving avg using SQL

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving avg using SQL
Date: 2009-09-04 16:57:01
Message-ID: 1252083421.3209.81.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2009-09-04 at 08:03 +0200, A. Kretschmer wrote:
> Which version do you have? Since 8.4 we have CTE aka windowing
> functions, a simple axample:

Minor terminology correction:

CTE stands for Common Table Expression, i.e. WITH [RECURSIVE].

Regards,
Jeff Davis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-09-04 17:21:24 Re: where clause question
Previous Message james bardin 2009-09-04 16:26:14 Verifying a PITR