On May 11, 2011, at 7:37 PM, John wrote:
> Igor,
> What you are suggesting will not work. You can only select values not
> columns using case.
>
>
> select case strftime('%w', 'now')
> when 0 then sunday_value
> when 1 then monday_value
> ...
> else saturday_value
> end
> from seven_days;
>
>
You must be new here. You have to understand the first rule of SQL. Igor is
never wrong. His query works just fine. See below --
sqlite> CREATE TABLE seven_days (
...> mon INTEGER,
...> tue INTEGER,
...> wed INTEGER
...> );
sqlite> INSERT INTO seven_days VALUES (5, 3, 2);
sqlite> INSERT INTO seven_days VALUES (1, 4, 3);
sqlite> INSERT INTO seven_days VALUES (7, 8, 3);
sqlite> SELECT CASE Strftime('%w', 'now')
...> WHEN 1 THEN mon
...> WHEN 2 THEN tue
...> ELSE wed
...> END AS day_val
...> FROM seven_days;
day_val
------------------------------------------------------------------------------
2
3
3
sqlite>
>
>
> On Wed, May 11, 2011 at 8:30 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
>
>> On 5/11/2011 8:14 PM, John wrote:
>>> I am in situation where I need to keep as much logic as possible within
>>> SQLite. However the query that I need to perform does not seem to be
>>> possible to perform.
>>>
>>> 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?
>>
>> select case strftime('%w', 'now')
>> when 0 then sunday_value
>> when 1 then monday_value
>> ...
>> else saturday_value
>> end
>> from seven_days;
>>
>> --
>> Igor Tandetnik
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> ~John
> _______________________________________________
> 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
