SQLite Forum

When was iff() added?

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,
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 [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.