[Babase] Validating ALLMISCS.Txt
Karl O. Pinc
kop at meme.com
Sat Jul 7 11:34:26 EDT 2007
Hi,
Looks like there are some "OS" type ALLMISCS rows. Are these valid?
(Lacey, note that the following SQL is, unlike what we did yesterday,
SQL standards compliant.)
babase=> select substring(allmiscs.txt from 1 for position(',' in
allmiscs.txt) - 1) as col1, count(*), max(samples.date) from allmiscs,
samples where samples.sid = allmiscs.sid group by col1;
col1 | count | max
------+-------+------------
OS | 3 | 2006-01-23
C | 563 | 2006-12-15
U | 990 | 2005-11-10
O | 573 | 2006-06-13
(4 rows)
babase=> select * from samples, allmiscs where samples.sid =
allmiscs.sid and substring(allmiscs.txt from 1 for position(',' in
allmiscs.txt) - 1) = 'OS' order by samples.date;
sid | date | stime | observer | stype | grp | sname | mins |
minsis | programid | setupid | palmtop | almid | sid | atime | txt
-------+------------+-------+----------+-------+------+-------+------+--------+-----------+---------+---------+-------+-------+----------+--------
13254 | 2002-02-16 | | JKW | J | 1.21 | OIL | 5
| 3 | 1 | 1 | 4 | 1084 | 13254 | 14:41:46 |
OS,,,,
34732 | 2006-01-23 | | RSM | F | 2.10 | LIW | 10
| 9 | 1 | 2 | 1 | 1981 | 34732 | 15:30:57 |
OS,
34732 | 2006-01-23 | | RSM | F | 2.10 | LIW | 10
| 9 | 1 | 2 | 1 | 1982 | 34732 | 15:31:20 |
OS,
(3 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