From: | Daniel Staal <DStaal(at)usa(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: SQL Question: Averages of intervals. |
Date: | 2009-01-24 18:19:48 |
Message-ID: | FFE62817A5AD3947E93E7102@Mac-Pro.magehandbook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
--As of January 24, 2009 11:16:31 AM -0500, Rodrigo E. De León Plicet is
alleged to have said:
> On Fri, Jan 23, 2009 at 3:39 PM, Daniel Staal <DStaal(at)usa(dot)net> wrote:
>> Is there any way to do this in straight SQL?
>
> Please provide:
>
> - DDL.
> - Sample data.
> - Expected output.
>
> Regards.
--As for the rest, it is mine.
If I can't get one of the other suggestions to work when I get back to the
office, I will.
(Sorry about the weekend wait: There was a misconfig in my email which
meant I couldn't see replies until I got home. Fixed.)
Daniel T. Staal
---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2009-01-25 00:39:09 | Re: removing leading and trailing blanks from every row in a table |
Previous Message | Robert Schnabel | 2009-01-24 17:01:19 | postgres.exe 100% CPU but no I/O |