Postgres Pro
Downloads
Home   >   mailing lists

Calculate difference between rows - Mailing list pgsql-general

From Detlef Jockheck
Subject Calculate difference between rows
Date
Msg-id 200303042056.h24KuQI04724@krakatau.jockheck.de
Whole thread Raw
List pgsql-general
Tree view 
Hi,

I have a table with two columns of the type

a date, b float:
2003-02-01, 47.2
2003-02-07, 26
2003-02-09, 55

Now I want to calculate a delta(b) / delta(a) from row to row. How can I
solve this in pgsql?

ciao
Detlef

--
# Dipl. Ing. (FH) Detlef Jockheck
# E-mail: detlef@jockheck.de
# -------------------------------

pgsql-general by date:

Previous
From: Richard Welty
Date:
Subject: Re: LinuxQuestions Award
Next
From: "Douglas Blood"
Date:
Subject: Re: problem with password