From: Christoph Haller <ch@rodos.fzk.de>
To: Octavio Alvarez <alvarezp@tecbc.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re:
Date: Mon, 21 Mar 2005 10:54:43 +0100
Message-ID: <423E99E2.7D428966@rodos.fzk.de> (raw)
References: <opsnuhhzgwg6g4in@octavio.tecbc.mx>
Octavio Alvarez wrote:
>
> Sorry, I tried to make my subject as good as possible.
Ahem, what subject?
>
> I have a table where I store the dates in which I take out of my inventory
> (like "installation dates")
>
> table
> ---------------
> row_id SERIAL
> date DATE
> fk_item INTEGER
>
> and that's pretty much it.
>
> I want to have a query returning how long have been certain items lasting.
>
> Say I have:
>
> SELCT date FROM table WHERE fk_item = "INKJET_INK-BW"
>
> date
> -------------
> 2005-02-02
> 2005-03-05
> 2005-04-07
> 2005-05-02
>
> I need something to calculate the intervals between those dates, like this:
>
> intervals (in days)
> --------------------
> 31
> 34
> 25
>
> So I can get the stddev and stuff from the "duration" of the items.
>
> I've been having a hard time with it. I'm trying NOT to program new
> functions.
I cannot see how this could be achieved without the use of a function.
But if there is a way after all, I would be interested in learning it.
>
> Any help will be appreciated.
>
> --Octavio
> --
Regards, Christoph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, alvarezp@tecbc.mx
Subject: Re:
In-Reply-To: <423E99E2.7D428966@rodos.fzk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox