Re: [sqlite] Seasonal syntax

2017-12-15 Thread Peter Da Silva 
SELECT name, address
CASE behaviour
  WHEN 'nice' THEN SELECT toy FROM stocking_stuffers ORDER BY random() LIMIT 1
  WHEN 'naughty' THEN 'coal'
  ELSE phnglui mgwlnafth cthulhu
  END

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Seasonal syntax

2017-12-14 Thread Rowan Worth 
On 14 December 2017 at 01:19, Warren Young  wrote:

> On Dec 12, 2017, at 10:24 AM, Simon Slavin  wrote:
> >
> >  Santa Clause: SELECT name,hobbies,address FROM people WHERE
> behaviour=‘nice’
>
> I think you mean
>
> SELECT name,address
> CASE behaviour
>   WHEN ‘nice' THEN
> hobbies
>   ELSE
> 'coal'
>   END
> FROM people
>

Surely "hobbies" should read something like:

(SELECT gift FROM ideas WHERE ideas.hobby IN (SELECT value FROM
json_each(hobbies)) ORDER BY random() LIMIT 1)

-Rowan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Seasonal syntax

2017-12-13 Thread Warren Young 
On Dec 12, 2017, at 10:24 AM, Simon Slavin  wrote:
> 
>  Santa Clause: SELECT name,hobbies,address FROM people WHERE 
> behaviour=‘nice’

I think you mean

SELECT name,address 
CASE behaviour
  WHEN ‘nice' THEN
hobbies
  ELSE
'coal'
  END
FROM people

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Seasonal syntax

2017-12-12 Thread Stephen Chrzanowski 
You had to do that just beclause

On Tue, Dec 12, 2017 at 12:24 PM, Simon Slavin  wrote:

> Some SQL terminology:
>
>   Selection Clause: WHERE 
>Sort Clause: ORDER BY 
> Sublist Clause: LIMIT  OFFSET 
> Subsort Clause: GROUP BY  HAVING 
>   Santa Clause: SELECT name,hobbies,address FROM people WHERE
> behaviour='nice’
>
> Season’s greetings and best wishes to all subscribers.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users