Richard Hipp <d...@sqlite.org> writes: > In 14 years, you are the first person to ask for them. That tells me that > probably not many people would use them even if we did put them in.
I've only written one program using sqlite a few years ago, and I had to make an ugly workaround using UNIONs and LEFT OUTER JOIN. I left a comment in the code that this should be replaced when sqlite supports FULL OUTER JOIN because the workaround can become extremely slow. Perhaps native support wont help speed, but sqlite might be in a better position to optimise than me. I would certainly try it out if it gets supported. I sorely missed that join back then, but I didn't ask for it since it's on the top of the list at https://www.sqlite.org/omitted.html At that time the page said "Those features near the top of the list are likely to be added in the near future". So I was thinking it would be a bit impolite or impatient to ask... -- Steinar _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users