Fallback value for column?

[lapidus]

I have a table holding translations. All entities have at least en (English) column defined but the other can be empty:

id, en, sv, es
sweden, Sweden, NULL, Suecia
norway, Norway, NULL, NULL

What are my best options to provide a fallback to English value for a particular language?

{
  table {
      value : sv 
   }
}

=> value: NULL

It would be really useful if there was some sort of directive or similar that "coalesces" English onto the value?

{
  table {
      value : sv @replaceIfNull(en)
   }
}

=> value: "Sweden"

Thanks!

[tirumaraiselvan]

You can create a view which selects the COALESCED value:

create view translations_with_defaults as
select coalese( sv, en), coalesce(es, en) from translations