On Mon, Apr 26, 2010 at 4:18 PM, Emilie Laffray <[email protected]>wrote:
> > > On 26 April 2010 15:12, John Smith <[email protected]> wrote: > >> 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 >> >> >> > It is fine ;) Your query uses a simpler schema that the one I am using. The > case statement is an absolute classic for selecting things without doing an > proper code :) > > Emilie Laffray > > This is not solving the original question : your query works outside Russia and other coutries where russian is not the default language. This is the discusion on the wiki page. Pieren
_______________________________________________ Tagging mailing list [email protected] http://lists.openstreetmap.org/listinfo/tagging
