-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Da Martian wrote: > Regarding using "Case" I didnt know sqlite supported this. In fact looking > at core functions on the web there isnt any mention of a case statement, nor > in aggregate functions.
Case is not a function but rather an expression. You can see the doc at http://www.sqlite.org/lang_expr.html which also covers a lot of other things, although it would be nice if the page included a case example. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkBmRwACgkQmOOfHg372QSCFACeNOY/PPpARA3BT+HUbteOR3+n 7aUAn3n7kczRGEhVWPqVF1PMgSuES2IW =dXC6 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users