On Sat, Oct 16, 2010 at 2:47 AM, Jim Morris <jmor...@bearriver.com> wrote:

>  Not much help but this removes the multiplication:
> SELECT B1.B + B2.B + B3.B + B4.B FROM
> (SELECT 0 AS B UNION SELECT 1 AS B) AS B1,
> (SELECT 0 AS B UNION SELECT 2 AS B) AS B2,
> (SELECT 0 AS B UNION SELECT 4 AS B) AS B3,
> (SELECT 0 AS B UNION SELECT 8 AS B) AS B4
>
>
thanks, Jim, thinking "binary" sometimes makes things more complicated than
it could be :)

Max
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to