[Babase] Query error?

Catherine Markham amarkham at princeton.edu
Thu Aug 24 22:02:48 EDT 2006


Hi all,

I have a question about the query below.  We were working in the new 
system this afternoon and Laurence wanted to select all the rows in 
repstats where a female was pregnant during 1999-2005.  What I tried was:

create table play4 as
select * from repstats where state = 'P' and date > '1999-12-31' and 
date < '2006-01-01' order by date;

This did give us an output which, as far as we could tell, seemed 
correct.  However, the system displayed a message saying there was a 
query error.

Karl and Leah, do you see the mistake?

Thanks,
Catherine


More information about the Babase mailing list