When was iff() added?
(1) By anonymous on 2020-09-24 08:50:47 [link]
Hi. I'm trying to use `iff()` <https://sqlite.org/lang_corefunc.html#iif> in my app, and getting `no such function: iff`. I've tried looking at <https://sqlite.org/changes.html> to see when it was added, but I'm not finding any reference to `iff`, that's not *sqldiff*, or *differ*, or *difference*. When was it added? For info, I'm using a *recent* 3.30.1. I'll revert to CASE, but I wish the doc included *since* mentions. My $0.02.
(2) By curmudgeon on 2020-09-24 09:03:08 in reply to 1 [link]
On the home page click on 'Prior Releases' then click on 3.32.3.
(3) By David Empson (dempson) on 2020-09-24 09:07:48 in reply to 1
The function is `iif()` with two i and one f, not `iff()` with one i and two f. If you search for the correct name in the changes list you will see it was added in 3.32.0, so your 3.30.1 is too old even with the correct spelling.
(4) By anonymous on 2020-09-24 09:18:27 in reply to 3 [link]
duh! Thank you both.