Clemens, Paul S, Abroży,
Thank you for taking the time to reply. I'll look at each of them and
see what makes the most sense to me.
It's always good to ask the people here as there is a wealth of
experience.
As suggestions popped in, I kept thinking go the unix competition which
was to list all the ways to accomplish printing something out, there's
always another to do it. I will learn here as well.
Many thanks to everybody,
Rob
On 16 May 2018, at 11:25, Clemens Ladisch wrote:
Rob Willett wrote:
select CASE
WHEN EXISTS (select 1 from blocked where email =
'rwillett.dr...@example.com')
THEN (select action from blocked where email =
'rwillett.dr...@example.com')
ELSE 'OK'
END
SELECT action FROM blocked WHERE email = ?
UNION ALL
SELECT 'OK'
LIMIT 1;
Regards,
Clemens
_______________________________________________
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
