[Babase] WeatherHawk design review
Karl O. Pinc
kop at meme.com
Fri Jul 3 00:17:03 EDT 2009
On 07/02/2009 11:07:54 PM, Karl O. Pinc wrote:
> I tried retrieving the 23:00 hour rainfall from the
> lst24hrrain column but had no luck:
>
> select wh2.whdaytime, wh2.lst24hrrain - wh1.lst24hrrain
> from whawks as wh1, whawks as wh2
> where wh2.whdaytime = wh1.whdaytime + '1 hour'::interval
> and extract('hour' from wh2.whdaytime) = 23
> and wh1.lst24hrrain = wh2.lst24hrrain
> order by wh2.whdaytime;
That should be:
and wh1.lst24hrrain != wh2.lst24hrrain
It was that way when I ran the query but it somehow
got left off the cut-and-paste. (?)
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list