On 22 Nov 2015, at 6:18pm, Scott Robison <scott at casaderobison.com> wrote:
> All technically correct (except the implication that a thousands separator > format is standard, as it is not). But the OP wants to be able to do > formatting from within SQL as he is using the SQLite shell, thus there is > no programming language at his disposal in this use case. An understandable > wishlist item, even if it isn't likely to happen for equally understandable > reasons. Actually, if it's in the shell I would have no objection with a view to code size, since code in the shell is not loaded when someone uses the SQLite API. In fact I might argue that it would be a good idea to move the whole of printf into the shell rather than have it as a core function as it is now. Of course that too is unlikely to happen, this time for backward-compatibility reasons. Maybe it could be a consideration of SQLite4. Simon.