> > I'm just curious how difficult it would be to add > support for booleans in SQLite. > >.... as well as use those keywords instead of creating integer > fields using 0 and 1. >
Check out StepSqlite PL/SQL compiler for SQLite which supports BOOLEAN data type among many other goodies. http://www.metatranz.com/stepsqlite It lets you script SQLite to do things like: create table admissions(fn varchar(20), ln varchar(20), accepted BOOLEAN); begin for student in (select * from admissions where accepted = TRUE) loop dbms_output.put_line('First name:' || student.fn || ' Last name:' || student.ln || ' Accepted: '|| student.accepted ); if student.accepted then dbms_output.put_line(student.fn ||' '|| student.ln || ' has been admitted.' ); else dbms_output.put_line(student.fn ||' '|| student.ln || ' has NOT been admitted.' ); end if; end loop; end; cheers :-) SK _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
