On 27 Oct 2019, at 9:12am, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> the discussion standard deviation has shown that at least STDEV and POWER > would be very helpful if they part of SQLite core. These are presentation issues. Not database issues. The results of such calculations are unlikely to be used to decide on the continuation of a SQL statement. Yes, "WHERE a < (b POWER c)" exists, but how often would you need it in real life ? SQLite is a database system. We shouldn't start to extend it to a presentation layer. Especially since it can't do something more fundamental than STDEV: return all surnames starting with the Unicode character 'Å'. I'm not entirely against adding facilities to SQLite. But I feel that they should be database things, not presentation things. For example, I think supporting more ALTER TABLE would be worthwhile. And I agree with you on RIGHT JOIN: it may duplicate what can be done with LEFT JOIN but many SQL facilities are duplicates. It's in SQL92 and people expect to see it. I am sometimes also in favour of adding a BOOLEAN type, even though it does not appear in SQL92. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
