Re: [Qgis-user] DB Manager query: Can't get CASE WHEN to work

Ok, sorry for the noise! comma missing after select * SQL and me not going to be good friends Cheers, Bernd Am 07.12.19 um 18:47 schrieb Bernd Vogelgesang: Hi, maybe it's again some strange local issue, but I can't find a way to make CASE WHEN working in a DB Manger query or in a Vitual

[Qgis-user] DB Manager query: Can't get CASE WHEN to work

Hi, maybe it's again some strange local issue, but I can't find a way to make CASE WHEN working in a DB Manger query or in a Vitual Layer. The example is analog to https://www.sqlitetutorial.net/sqlite-case/ I would like to populate a new column "category" in that select SELECT * CASE WHEN