bigmetadata icon indicating copy to clipboard operation
bigmetadata copied to clipboard

OBS_GetMeta won't complain if column doesn't exist

Open danicarrion opened this issue 6 years ago • 0 comments

Imagine a query such as this one:

WITH meta AS (
  SELECT OBS_GetMeta(
    ST_SetSRID(ST_Extent(the_geom), 4326),
      '[
        {
          "numer_id":"es.ine.pop_0_4_male",
          "normalization":"area"
        },
        {
          "numer_id":"es.ine.pop_5_10_male",
          "normalization":"area"
         },
....

es.ine.pop_5_10_male doesn't actually exist as a column, but OBS_GetMeta will simply remove that column from the result. Shouldn't it raise an error instead?

danicarrion avatar Aug 28 '18 10:08 danicarrion