Sorry I don't use pgsql much, I used ' instead of ", should be: (CASE WHEN "name:ru" IS NOT NULL THEN "name:ru" WHEN "name:en" IS NOT NULL THEN "name:en" ELSE name END) AS name