search

CartoDB / crankshaft

CARTO Spatial Analysis extension for PostgreSQL
BSD 3-Clause "New" or "Revised" License
54 stars 20 forks source link

markov fails with empty columns #82

Open javisantana opened 8 years ago

javisantana commented 8 years ago 
SELECT * from cdb_crankshaft.CDB_SpatialMarkovTrend('select '''' as _1997_11, ''1'' as _1997_12 from markov_test', ARRAY['_1997_11','_1997_12']);

fails because markov is only checkings nulls

andy-esch commented 8 years ago

I could check for '' as well, but maybe I should just enforce that the input column types are numeric instead? If not, the function would have to add some interpretation about the user's input data (does a '' correspond to a null?)