[gdal-dev] OGR SQL on CSV file with field name with parentheses?

Fri Apr 19 10:49:23 PDT 2019

Good to know why this syntax works.  It brings back fond memories of using MS Access 😊

-----Original Message-----
From: Even Rouault <even.rouault at spatialys.com> 
Sent: Friday, April 19, 2019 10:42 AM
To: gdal-dev at lists.osgeo.org
Cc: Moskovitz, Bob at DOC <Bob.Moskovitz at conservation.ca.gov>; John Baumgartner <johnbaums at gmail.com>
Subject: Re: [gdal-dev] OGR SQL on CSV file with field name with parentheses?

On vendredi 19 avril 2019 16:05:14 CEST Moskovitz, Bob at DOC wrote:
> Thanks John, it worked perfectly!

oh, indeed. Turns out SQLite is rather permissive in that area:
https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sqlite.org%2Flang_keywords.html&data=02%7C01%7CBob.Moskovitz%40conservation.ca.gov%7Cf0ba36de77384ea4297108d6c4ee6494%7C4c5988ae5a0040e8b065a017f9c99494%7C0%7C0%7C636912925503570904&sdata=8dT7SGvGNq3lscnpcOkOhA4t2QNkh7UL9B7eiDW7Sxk%3D&reserved=0
(that said, OGR SQL only accepts double quotes when identifier quoting is 
needed)

-- 
Spatialys - Geospatial professional services
https://gcc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.spatialys.com&data=02%7C01%7CBob.Moskovitz%40conservation.ca.gov%7Cf0ba36de77384ea4297108d6c4ee6494%7C4c5988ae5a0040e8b065a017f9c99494%7C0%7C0%7C636912925503570904&sdata=2PT287%2BeOJIl9i73dhes%2BVuh4AD%2BPnn1MswgWO3eHk0%3D&reserved=0