On 2014/10/07 12:13, Tony Papadimitriou wrote:
Thanks.
It seems quite a bit more verbose than the IF() function, but it works, so I
can't complain.
As an aside - It's not only a little more verbose, it also happens to be the way prescribed by the SQL standard and to my knowledge
MySQL, Oracle, PostGres and SQLServer all support it very well... the fact that some of them add other functions (such as the
IF(eval, when true, when false) construct) for of ease of reading and user preference is quite helpful but then they are not
constrained by the "Lite" moniker and can rack up those megabytes without a care in the world.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users