area field in department, region and city has a string type instead of float type

[loco-philippe]

Query without cast has no result.

SELECT 
        SUM(city.area::float) AS total
FROM
    city

Note : The areafield of epci is correct (float)

[jmaupetit]

This has been validated using:

SELECT
  table_name,
  column_name,
  data_type
FROM
  information_schema.columns
WHERE
  table_name IN ('city', 'department', 'epci', 'region')
  AND column_name = 'area'

Which gives:

table_name	column_name	data_type
epci	area	double precision
city	area	text
department	area	text
region	area	text