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
_______________________________________________ Tagging mailing list [email protected] http://lists.openstreetmap.org/listinfo/tagging
