Le 13/05/2013 20:23, Christian Quest a écrit :
Une suggestion pour un truc plus simple que:
cast(cast('0' ||
regexp_replace(coalesce(tags->'ele',tags->'ele:local'),'[^0-9\\.]','','g')
as real) as integer) as ele
pas testé car pas de base sous la main :split_part(coalesce(tags->'ele',tags->'ele:local',0)||'.0','.',1)::integer as ele
vincent _______________________________________________ Talk-fr mailing list Talk-fr@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-fr
