Glossary: SQL Beyond the Basics
iif
Also written: IIF()
A SQLite function for a single yes-or-no test, such as `iif(price >= 50, 'big', 'small')`. PostgreSQL doesn't have it, so CASE is the portable choice.
Glossary: SQL Beyond the Basics
Also written: IIF()
A SQLite function for a single yes-or-no test, such as `iif(price >= 50, 'big', 'small')`. PostgreSQL doesn't have it, so CASE is the portable choice.