too much logic On Wed, May 11, 2011 at 9:01 PM, John <tauru...@gmail.com> wrote:
> I should have done it like that (normal referential table). But now I'm at > the end of this project and too logic uses that table already. So perhaps > I'll refactor some day. > > > On Wed, May 11, 2011 at 8:56 PM, Igor Tandetnik <itandet...@mvps.org>wrote: > >> On 5/11/2011 8:52 PM, John wrote: >> > here is the view: >> > >> > create view today_goal as >> > select 'monday' dow, monday_goal value from user_goals >> > union all >> > select 'tuesday' dow, tuesday_goal value from user_goals >> > union all >> > select 'wednesday' dow, wednesday_goal value from user_goals >> > union all >> > select 'thursday' dow, thursday_goal value from user_goals >> > union all >> > select 'friday' dow, friday_goal value from user_goals >> > union all >> > select 'saturday' dow, saturday_goal value from user_goals >> > union all >> > select 'sunday' dow, sunday_goal value from user_goals; >> > >> > select dow, value from today_goal; >> >> I kind of wonder why you can't just set up your original table this way >> to begin with, and not bother with the view. >> -- >> Igor Tandetnik >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > ~John > -- ~John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
