On Thu, Feb 6, 2014 at 5:36 PM, Richard Hipp <[email protected]> wrote:

> a UNION or UNION ALL and (2) there is exactly one self-reference in the
> right-hand SELECT of the UNION or UNION ALL.
>

i see now that my example isn't actually recursive due to (2).

Thanks for the detailed explanation!

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to