[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