When was iff() added?
(1) By anonymous on 2020-09-24 08:50:47 [link] [source]
Hi. I'm trying to use
iff() https://sqlite.org/lang_corefunc.html#iif in my app,
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 [source]
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 [link] [source]
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] [source]
duh! Thank you both.