[Tagging] Names localization

[Pieren]

On Mon, Apr 26, 2010 at 4:18 PM, Emilie Laffray <emilie.laffray at gmail.com>wrote:

>
>
> On 26 April 2010 15:12, John Smith <deltafoxtrot256 at gmail.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tagging/attachments/20100426/7617824d/attachment.html>