[Babase] Problems with ALLMISCS.Atime data
Karl O. Pinc
kop at meme.com
Fri Jul 13 17:39:20 EDT 2007
Hi,
In the process of allowing both 'O' and 'U' type
ALLMISCS.Txt data I'm now adding additional
validation to ALLMISCS. One thing I'm doing
is testing ALLMISCS.Atime and limiting it like
I'm limiting POINT_DATA.Ptime -- to between
05:00 and 19:00, inclusive.
The following ALLMISCS rows have bad Ptime values,
values > 19:00. These need to be fixed. Now
that we're not converting any longer, and these
rows are already in the database, this email is
the only record of the problem with this data
so please take care not to lose track of this
task.
(This query "limited" to avoid revealing data
on a public mailing list.)
babase=> select almid, sid from allmiscs where atime > '19:00';
almid | sid
-------+-------
50 | 2937
374 | 5321
408 | 5596
409 | 5596
416 | 5645
417 | 5662
464 | 6135
2041 | 36783
(8 rows)
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