We support string value for spatial field such as Lincoln, Nebraska, as documented here. But in reality:
Lincoln, NE is supported, NOT Lincoln, Nebraska
Brown County, Nebraska is supported, NOT Brown County, NE
The reason is the how the values are present in the locations table. We need to introduce some logic in the code so that all four values are supported.
How to reproduce
See the difference in the query results:
catalog=# select name from locations where name like '%Nebraska';
catalog=# select name from locations where name like '%NE';
Sketch
[Notes or a checklist reflecting our understanding of the selected approach]
hkdctol
commented
6 months ago
We support string value for spatial field such as
Lincoln, Nebraska, as documented here. But in reality:Lincoln, NEis supported, NOTLincoln, NebraskaBrown County, Nebraskais supported, NOTBrown County, NEThe reason is the how the values are present in the locations table. We need to introduce some logic in the code so that all four values are supported.
How to reproduce
See the difference in the query results:
Sketch
[Notes or a checklist reflecting our understanding of the selected approach]