Wonderful. The other answer is that one probably should not have a table with seven columns and one row when one could have a table with two columns (day of week and value) and seven rows. Like the view you are suggesting.
--David Nico Williams writes: > On May 11, 2011 7:14 PM, "John" <tauru...@gmail.com> wrote: > > let's say I have a table with columns for each day of the week > > > > create table seven_days > > (monday_value integer, > > tueday_value integer, > > wednesday_value integer, > > ... ); > > > > I want to select value from whatever day it is today. So if today is > > Tuesday, select from tuesday_value. > > > > Can I do it with pure SQlite? > > Sure. First setup a view that consists of a union of queries one for each > day, with a column whose value is the day of the week. Then query that > view. > > Nico > -- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users